Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hirples” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

442 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hirples1214964(None) 
hirple11158971hirple_
hirpled13157131hirpled
hirsles101510071hirsles
birles84920642bir_les
circles1139902circles
dimples122813212dimples
fipples14298652fipples
girdles92210002girdles
harpies123818312harpies
herpes115517322herp_es
higgles123911802higgles
hipless12399922hi_pless
hippies142813742hippies
hirees95117292hir_ees
hires86134342hir__es
hirsels10128342hirsels
hirsle9159572hirsle_
hirsled11118112hirsled
hopples142810712hopples
hurdles113613372hurdles
hurtles103913752hurtles
kirtles11309662kirtles
nipples11319662nipples
pimples133012422pimples
purples112712822purples
rimples113114222rimples
ripples113513292ripples
simples113014942simples
tipples112811252tipples
triples94616872triples
wimples143311172wimples
airholes1138033airholes
airless73712043air_less
airplanes1187233airplanes
airplay1245483airplay
airplays1344533airplays
aisles64721143ai_sles
apples104315763_apples
argles75218483_argles
arles56735743_ar_les
bibles104617643bi_bles
biles75542143bi__les
bindles104016453bindles
birches143412323birches
birdies104016213birdies
biremes1138773biremes
birkies133712433birkies
birle75023633bir_le_
birled94416993bir_led
birler85715083bir_ler
birlers93813003bir_lers
birls74023163bir_l_s
birses84717733bir_ses
bridles104114473bridles
burbles114916803burbles
burgles105615963burgles
carles85435083car_les
carpels115315463carpels
chicles143512503chi_cles
chiles115425303chi__les
chippies17309753chippies
chirped15379783chirp_ed
chirper14359963chirp_er
chirpers15358133chirpers
chirpier15276303chirpier
chirpiest16286473chirpiest
chirps135414003chirp__s
chirres123812253chir_res
chorales133712873chorales
chortles133611323chortles
circle1039703circle_
circled1237583circled
circler1136423circler
circlers1235343circlers
circlet11311473circlet
circlets1235663circlets
cires74932913cir__es
cirques1836463cirques
citoles9312553citoles
corpses113913803corpses
couples115317053couples
crimples14308963crimples
cripes105120873crip_es
cripples14298403cripples
curdles103814573curdles
dapples1238993dapples
darkles124011933darkles
dartles84014133dartles
dibbles124013333dibbles
diddles103915073diddles
dimple113512793dimple_
dimpled132810303dimpled
dindles93817243dindles
dingles93818323dingles
diplex16408053di_plex
diploes101111483di_ploes
dipoles101013753dipoles
dirges84915103dir_ges
dirled84514903dir_led
dirls64720503dir_l_s
dirties83119383dirties
dispels10310503dispels
dripless1135243dripless
farles96025783far_les
ferules103112723ferules
fiddles123212603fiddles
files85441273fi__les
filles94224523fi_lles
fimbles143510653fimbles
finales104016013finales
fipple13329063fipple_
fireless112810593fireless
fires85740753fir__es
fizzles18339063fizzles
garbles104016923garbles
gargles94214893gargles
giggles103312933giggles
girdle82110463girdle_
girdled10217453girdled
girdler9227313girdler
girdlers10195403girdlers
girlies83013703girlies
girls64518393gir_l_s
girolles935523girolles
girshes11248293girshes
grilles83715023grilles
gripes94619873grip_es
grippes124810373grippes
gurgles94312873gurgles
hackles162917063hackles
haggles123312483haggles
hairless1157413hair_less
hairpins1365433hairpins
hales85449843h__ales
handles114020653handles
hantles104117513hantles
haoles94919803h_aoles
hapless123311333h_apless
hardies114923233hardies
hares86255543har__es
harls85634503har_l_s
harmless1337403harmless
harped124418403harp_ed
harper115018403harp_er
harpers124916203harpers
harpins123615703harpins
harps105926863harp__s
harries103525493harries
harslet10315653harslet
harslets1137833harslets
hassles103411693hassles
heckles163711383heckles
heddles123311623heddles
heirless1146053heir_less
helpless1335063helpless
heralds1137703heralds
herbless1336663herbless
hercules1337633hercules
heredes11313133heredes
heres86245903her__es
herls85226433her_l_s
heroes94923823her_oes
herries104025073herries
hertzes1938293hertzes
hickies163614743hickies
hideless12278713hideless
hides95129423hi__des
hidroses1237903hidroses
hies74842833hi___es
higgle113811743higgle_
higgled13339073higgled
higgler12369803higgler
higglers13297223higglers
hikes125426983hi__kes
hilled104022223hi_lled
hiller94421633hi_ller
hillers103718723hi_llers
hilloes103815943hilloes
hillos94618883hi_llos
hills85431353hi__lls
hiltless11297123hiltless
hilts86924413hi__lts
hilus84817643hi__lus
hinges105121023hi_nges
hinnies103615103hinnies
hiplines13310583hi_plines
hiply134113613hi_pl_y
hipness12277383hi_pness
hipped144317693hi_pped
hipper133818023hi_pper
hippest14219753hi_ppest
hippie132811243hippie_
hippier143212103hippier
hippiest152611613hippiest
hippos13408433hi_ppos
hips96433703hi_p__s
hirable121612313hirable_
hire75538963hir__e_
hired95226263hir__ed
hiree85427803hir__ee
hirer85423123hir__er
hirers94518063hir_ers
hirpling1467223hirpling
hirsel9138683hir_sel
hirseled12106253hirseled
hisses94719353hi_sses
hissies103915823hissies
hitches153616273hitches
hitless103211193hi_tless
hiveless14227933hiveless
hives116925513hi__ves
hobbles143313783hobbles
holes84748653h__oles
hondles113614523hondles
hooplas1239193hooplas
hoopless13279253hoopless
hoopoes121212483hoopoes
hopes105835643h_op_es
hopple132910483hopple_
hoppled15338083hoppled
hordes104921633hor_des
hornless1137363hornless
horses94729343hor_ses
horstes104516113horstes
hoyles12315013h_oyles
huckles163612623huckles
huddles123712573huddles
huipiles1344423huipiles
humbles143215803humbles
humpless15226333humpless
hurdies114015663hurdies
hurdle103712793hurdle_
hurdled12379833hurdled
hurdler113610003hurdler
hurdlers12337493hurdlers
hurled104617453hur_led
hurler94717223hur_ler
hurlers103714323hur_lers
hurley125012523hur_ley
hurleys13407333hur_leys
hurlies103315333hurlies
hurls86522713hur_l_s
hurries103919653hurries
hurtle93512943hurtle_
hurtled11339593hurtled
hurtless11307783hurtless
hustles103414173hustles
hypes135818673h_yp_es
hyraces1537913hyraces
hyraxes2045703hyraxes
idles66720123_i_dles
impales113311763_impales
impels10389513_impels
impled113812503_impled
implies11312113_implies
ingles74420873_ingles
inkles103515653_inkles
irades74517393_irades
ireless72312243_ireless
ires45639283_ir__es
irides74519123_irides
irises64221173_irises
irones64724013_irones
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jiggles164111433jiggles
jingles153816383jingles
kibbles153510253kibbles
kindles123614843kindles
kirtle10309473kirtle_
kirtled12287033kirtled
kittles113012493kittles
ligules82210913ligules
lipless9259553li_pless
lisles63416283li_sles
littles73212783littles
maples104819423_maples
marbles114516653marbles
merles85322763mer_les
mickles153415003mickles
middles113415303middles
miggles113512033miggles
miles74645073mi__les
milles84526563mi_lles
mingles103719003mingles
miracles1238333miracles
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
mispled12310463mispled
misrules1039383misrules
mizzles17329493mizzles
morales93619403morales
myrtles1235733myrtles
nibbles114011693nibbles
nickles133713823nickles
niggles93512203niggles
nipple103410373nipple_
nippled12307643nippled
nitriles8269923nitriles
orioles7412993orioles
orles55326213_or_les
parles86334393par_les
paroles95025883paroles
peoples11312213peoples
perplex1836133perplex
pickles153215443pickles
piddles114314273piddles
piffles15368763piffles
piles74742613pi__les
pilules9510623pilules
pimple123512963pimple_
pimpled14289183pimpled
pinoles93418703pinoles
pintles94118723pintles
pipes96030143pi_p_es
pirates93020323pirates
pizzles17329273pizzles
popples103011873popples
proles84627203_proles
purfles122511843purfles
purple102712673purple_
purpled12299753purpled
purpler11289263purpler
purplest12249123purplest
rales54947493__rales
riddles93215023riddles
riffles133911163riffles
rifles94217703ri_fles
riles55343643__riles
rilles64725503ri_lles
rimple103814583rimple_
rimpled123311423rimpled
ripes75435773ri_p_es
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripplers12337113ripplers
ripplet113412583ripplet
ripplets12316733ripplets
roles56747983__roles
rules55234253__rules
rumples113313133rumples
samples112815453samples
scruples1237433scruples
sharpies13411223sharpies
shingles123111103shingles
shipless13277693shi_pless
shires95225573shir__es
shirtless12266413shirtless
sickles133417543sickles
sidles74721153si_dles
similes92915233similes
simple104315173simple_
simpler112910863simpler
simplest122310223simplest
simplex18256393simplex
singles83520433singles
sipes76036953si_p_es
sirees64624583sir_ees
sires55945373sir__es
sirrees73410563sirrees
sizzles15349633sizzles
staples93617213staples
stipples1247023stipples
stirpes95011293stirp_es
supples11511283supples
surplus936793surplus
swiples12339643swiples
swipples1534843swipples
temples112610893temples
thimbles1536013thimbles
thirled11328093thir_led
thirls95012063thir_l_s
thirties1139723thirties
thistles1198233thistles
thorpes125010353thorp_es
tickles133416853tickles
tiles55542103ti__les
tingles83818313tingles
tinkles113713923tinkles
tipless92610063ti_pless
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipplers12336353tipplers
tirades8311723tirades
tireless82510263tireless
tires55437493tir__es
tirled74714363tir_led
tirls54519803tir_l_s
titles63719923ti_tles
tittles73413253tittles
topples113111653topples
trifles103814823trifles
tripes85324873trip_es
triple84215923triple_
tripled104113833tripled
triplet94319213triplet
triplets103510263triplets
triplex16447803triplex
turtles72914343turtles
vires84529683vir__es
virgules1244333virgules
virile9313433virile_
virls85618603vir_l_s
viroses10310533viroses
virtues10338023virtues
viruses1039413viruses
vittles103211113vittles
warbles123215563warbles
warsles103413643warsles
wheeples1634743wheeples
whiffles2034263whiffles
whiles124418013whi__les
whirled14368043whir_led
whirler13307603whir_ler
whirlers14286053whir_lers
whirlies14167373whirlies
whirls124710533whir_l_s
whirries14136693whirries
whistles14108213whistles
whittles1496673whittles
whortles14306743whortles
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010843wimbles
wimple133611363wimple_
wimpled15338823wimpled
windles113518493windles
winkles143412773winkles
wintles103414983wintles
wipes104827083wi_p_es
wireless11249633wireless
wires86034913wir__es
yipes106017843yi_p_es
yippies14279293yippies
zipless18276303zi_pless
zizzles14307093zizzles

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340274426.92319359.7
3Display Results4424420.1532888.9
 (SQL Overall)1786914427.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.