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

177 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
whirries1413670(None) 
wherries14179031wherries
whirlies14167371whirlies
whirried15154111whirried
cherries131812992cherries
chirres123812252chirr_es
dhurries1255582dhurries
gharries12318222gharries
harries103525502_harries
herries104025082_herries
hurries103919652_hurries
sherries111812902sherries
thirties1139722thirties
weirdies12255782weirdies
wherried15175022wherried
whimsies1635192whimsies
whinnies14237282whinnies
whirlier14175292whirlier
whirliest15216042whirliest
whirred14386942whirr_ed
whirring15286282whirring
whirrs12408592whirr__s
whiskies1835952whiskies
whities133113252whi_ties
worries104117132w_orries
apiaries10312733apiaries
aviaries1139783aviaries
berries94423553_berries
bhisties1339003bhisties
birdies104016213_birdies
birkies133712433_birkies
carries94328013_carries
charlies133414233charlies
charrier1378693charrier
charriest1438263charriest
chicories1688773chicories
chilies124218303chi_lies
chillies134113483chillies
chippies17309763chippies
chirpier15276303chirpier
chirpiest16286483chirpiest
chirre114111853chirr_e_
chirred133612123chirr_ed
chirren12388743chirr_en
chirring142610173chirring
chirrs114514983chirr__s
chirrups15133043chirrups
chitties13310773chitties
chivaries1757433chivaries
chivies153412853chi_vies
chivvies1954423chivvies
corries94026803_corries
curries93723163_curries
dairies84217733dai_ries
derries83124623_derries
dhurrie1153953dhurrie_
diaries83321953_diaries
dirties83119383_dirties
durries83817353_durries
fairies103516043fai_ries
ferries103521083_ferries
firrier103410133_firrier
firriest112310433_firriest
flurries11188913flurries
friaries11310083friaries
gharris11306433gharri_s
ghillies12408663ghillies
girlies83013703_girlies
gurries83515953_gurries
hardies114923233_hardies
harpies123818323_harpies
harried113815543_harried
harrier104417763_harrier
harriers113712433_harriers
henries102718283_henries
herried113514473_herried
hickies163614743_hickies
hinnies103615113_hinnies
hippies142813753_hippies
hirees95117293_hi_rees
hires86134343_hi_r_es
hirples12149643_hirples
hirsles101510073_hirsles
hissies103915823_hissies
hurdies114015663_hurdies
hurlies103315333_hurlies
hurried113511043_hurried
hurrier103412943_hurrier
hurriers11358893_hurriers
jerries143817513_jerries
kerries113317913_kerries
lorries74518353_lorries
marries93825283_marries
murries94118673_murries
parries93925843_parries
perries93226603_perries
priories10312453priories
quarries1749943quarries
scurries102911483scurries
serries73925353_serries
sharpies13411233sharpies
sherris10168803sherri_s
sherrises12156873sherrises
shimmies15287803shimmies
shindies122610503shindies
shinnies113010923shinnies
shires95225573shi_r_es
shirred113710503shirr_ed
shirring122910443shirring
shirrings13245323shirrings
shirrs94413173shirr__s
shirtier1137943shirtier
shirtiest1239333shirtiest
shorties11414583shorties
sirrees73410573_sirrees
skerries12168673skerries
slurries82710413slurries
spurries102311323spurries
tarries73324263_tarries
terries73425633_terries
theories11311593theories
wastries111212883wastries
wearies103020233w_earies
weirdie11224063weirdie_
weirdoes12323843weirdoes
whammies18265513whammies
wharves16457143wh_arves
wheelies1437873wheelies
wheres125917443wh_er_es
wherves16548063wh_erves
whiffles2034263whiffles
whiles124418013whi__les
whimsied1743113whimsied
whines125120103whi__nes
whinges143610633whi_nges
whinier134110633whi_nier
whiniest14298753whi_niest
whinnied15284163whinnied
whinnier14255013whinnier
whinniest15245143whinniest
whippier18265823whippier
whippiest19265123whippiest
whiprays1942503whiprays
whirled14368043whi_rled
whirler13307603whi_rler
whirlers14286053whirlers
whirling15237163whirling
whirls124710533whi_r_ls
whirr114611193whirr___
whirry15477063whirr__y
whirrying1962733whirrying
whirs115218093whi_r__s
whishes16309443whi_shes
whistles14108213whistles
whites123919883whi__tes
whitier133311063whi_tier
whitiest14259883whi_tiest
whittles1496673whittles
whizzes2134713whi_zzes
whizzier2233283whizzier
whizziest2342883whizziest
whoopies16267373whoopies
whores125617103wh_or_es
whortles14306743whortles
widdies123514033w_iddies
wienies102213683w_ienies
willies103920153w_illies
wineries112316533wineries
wires86034913w_i_r_es
wirier94215553w_i_rier
wiriest103816853w_i_riest
withies133913543w_ithies
worried11308693w_orried
worrier102311683w_orrier
worriers11257813w_orriers
worrits10258683w_orrits
wries85827743w___ries

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.453394461.4
2DLD Change Limit1461621777.04620744.0
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.56223630.1
 
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.