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 “whirlies” 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.

188 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
whirlies1416737(None) 
whirlier14175291whirlier
whirliest15216041whirliest
whirries14136691whirries
charlies133414232charlies
chilies124218302chi_lies
chillies134113482chillies
ghillies12408662ghillies
girlies83013702_girlies
hurlies103315332_hurlies
thirties1139722thirties
weirdies12255782weirdies
wheelies1437862wheelies
wherries14179022wherries
whiles124418012whi_l_es
whimsies1635192whimsies
whinnies14237272whinnies
whirled14368042whirl_ed
whirler13307602whirl_er
whirlers14286052whirlers
whirling15237162whirling
whirls124710532whirl__s
whirried15154102whirried
whiskies1835952whiskies
whities133113252whi_ties
willies103920152w_illies
airlines8312793_airlines
bailies94120203bai_lies
bhisties1339003bhisties
bialies93618413_bialies
billies93923503_billies
birdies104016213_birdies
birkies133712433_birkies
birles84920643_birl_es
challies133915643challies
charlie123011923charlie_
cherries131812983cherries
chicles143512503chicl_es
childes134211273chi_ldes
chiles115425303chi_l_es
chilis115517873chi_li_s
chillier13328423chillier
chilliest14358913chilliest
chillis124411603chilli_s
chimblies1845033chimblies
chippies17309753chippies
chirpier15276303chirpier
chirpiest16286473chirpiest
chirres123812253chir_res
chitlins13289393chitlins
chitties13310773chitties
chivies153412853chi_vies
chivvies1954423chivvies
dailies84219263dai_lies
dairies84217733dair_ies
dhoolies1246963dhoolies
dhurries1255583dhurries
dillies84122163_dillies
dirties83119383_dirties
doilies84017363doi_lies
fairies103516043fair_ies
ferlies103216693_ferlies
fillies103420253_fillies
gharries12318203gharries
ghiblis1353343ghibli_s
ghillie11326353ghillie_
ghoulies1235393ghoulies
gillies84120963_gillies
girlie73711463_girlie_
girlier8289523_girlier
girliest93010403_girliest
hairlines1237133hairlines
hardies114923233_hardies
harpies123818313_harpies
harries103525493_harries
herries104025073_herries
hickies163614743_hickies
hillier103413963_hillier
hilliest113914113_hilliest
hilloes103815963_hilloes
hinnies103615103_hinnies
hiplines13310593_hiplines
hippies142813743_hippies
hirees95117293_hir_ees
hires86134343_hir__es
hirples12149643_hirples
hirsles101510073_hirsles
hissies103915823_hissies
holies94630033_h_olies
hollies103420813_hollies
hourlies1138343hourlies
hurdies114015663_hurdies
hurries103919653_hurries
killies113318113_killies
lilies63021413_li_lies
mislies92922283_mislies
overlies112417043overlies
sharpies13411223sharpies
sherries111812893sherries
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shires95225573shir__es
shirtier1137943shirtier
shirtiest1239323shirtiest
shorties11414583shorties
sillies73425083_sillies
swirlier1135213swirlier
swirliest1236293swirliest
thirlages1343763thirlages
thirled11328093thirl_ed
thirling12248583thirling
thirls95012063thirl__s
twirlier1133513twirlier
twirliest1234503twirliest
walies95324523w__alies
wallies103320743w_allies
wearies103020223wear_ies
weeklies1534913weeklies
weirdie11224063weirdie_
weirdoes12323833weirdoes
wellies103719073w_ellies
whales124716943wh_al_es
whammies18265513whammies
wharves16457133whar_ves
wheelie1336193wheelie_
wheres125917433wher__es
wherried15175013wherried
wherves16548053wher_ves
whiffles2034263whiffles
while115418693whi_l_e_
whiled134514133whi_l_ed
whiling143511743whi_ling
whimsied1743113whimsied
whines125120103whi__nes
whinges143610633whi_nges
whinier134110633whi_nier
whiniest14298753whi_niest
whinnied15284153whinnied
whinnier14255003whinnier
whinniest15245133whinniest
whiplike2043813whiplike
whippier18265823whippier
whippiest19265113whippiest
whirl114913823whirl___
whirligig175863whirligig
whirligigs185843whirligigs
whirlwind1941513whirlwind
whirlwinds2051113whirlwinds
whirly15448863whirl__y
whirred14386933whir_red
whirring15286283whirring
whirrs12408593whir__rs
whirs115218093whir___s
whishes16309443whi_shes
whistles14108213whistles
whiteflies1942223whiteflies
whites123919883whi__tes
whitier133311063whi_tier
whitiest14259883whi_tiest
whitlows1743083whitlows
whittles1496673whittles
whizzes2134713whi_zzes
whizzier2233283whizzier
whizziest2342883whizziest
wholes124616773wh_ol_es
whoopies16267373whoopies
whores125617103whor__es
whorled14366903whorl_ed
whorls124410163whorl__s
whortles14306743whortles
widdies123514033w_iddies
wienies102213683w_ienies
wiles85437873w_i_l_es
wilier93217073w_i_lier
wiliest103416593w_i_liest
willie94116453w_illie_
willied114611563w_illied
wires86034913w_ir__es
wirier94215553w_ir_ier
wiriest103816853w_ir_iest
withies133913543w_ithies
wobblies15297233wobblies
woolies104117363w_oolies
woollies1147413woollies
worries104117133w_orries
wries85827743w__r_ies
yearlies1137603yearlies

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621887.28320068.9
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.51223787.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.