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

205 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
wherries1417902(None) 
cherries131812981cherries
herries104025071_herries
sherries111812891sherries
wherried15175011wherried
whirries14136691whirries
berries94423552_berries
derries83124622_derries
dhurries1255582dhurries
ferries103521082_ferries
gharries12318212gharries
harries103525492_harries
henries102718282_henries
herried113514462_herried
hurries103919652_hurries
jerries143817512_jerries
kerries113317912_kerries
perries93226602_perries
serries73925352_serries
sherris10168802sherri_s
sherrises12156862sherrises
skerries12168672skerries
terries73425632_terries
theories11311592theories
wearies103020222w_earies
wheelies1437862wheelies
wheres125917432whe_r_es
wherves16548052whe_rves
whirlies14167372whirlies
whirried15154102whirried
worries104117132w_orries
abhenries1444503abhenries
aeries64737783_ae_ries
anergies9310453anergies
aperies9423203ape_ries
berried103714053_berried
carries94328013_carries
charlies133414233charlies
charrier1378683charrier
charriest1438263charriest
cheapies1539033cheapies
cheerier1348003cheerier
cheeriest1438213cheeriest
cheerios13317583cheerios
chertier1387873chertier
chertiest1438793chertiest
chervils1644553chervils
chevies153511443che_vies
chevres15379793chevr_es
chirres123812253chirr_es
clergies1137903clergies
corries94026803_corries
cowberries1744623cowberries
curries93723163_curries
dearies83526273_dearies
decries103319813_decries
derbies103016053_derbies
derris73615273_derri_s
derrises93012783_derrises
dewberries1643533dewberries
dhurrie1153953dhurrie_
drearies92313413drearies
durries83817353_durries
emeries91620023eme_ries
energies9310783energies
equerries1844883equerries
eyries93816813__eyries
faeries104118993fae_ries
ferlies103216693_ferlies
ferried113411533_ferried
ferrites112312833_ferrites
flurries11188913flurries
gharris11306433gharri_s
gheraoes1244813gheraoes
gherkins1643993gherkins
gurries83515953_gurries
hardies114923233_hardies
harpies123818323_harpies
harried113815533_harried
harrier104417753_harrier
harriers113712433_harriers
hearses104414533_hearses
hearties11315413_hearties
heavies132713873_heavies
heinies102514543_heinies
herbier1239593_herbier
herbiest1339993_herbiest
herdics13249523_herdics
heredes11313133_heredes
heres86245903_he_r_es
heresies11312703_heresies
hermits12312143_hermits
hernias10310773_hernias
heroes94923823_he_roes
heroics122912003_heroics
heroines112916573_heroines
heroins103518013_heroins
heroizes202610983_heroizes
heronries1248493_heronries
herpes115517323_he_rpes
herring113615883_herring
herrings12379533_herrings
hertzes1938303_hertzes
hurdies114015663_hurdies
hurlies103315333_hurlies
hurried113511043_hurried
hurrier103412943_hurrier
hurriers11358893_hurriers
jerkies183411583_jerkies
jerrids15277743_jerrids
kerrias11289513_kerrias
lorries74518353_lorries
marries93825283_marries
mercies113817563_mercies
merrier92612303_merrier
merriest10311483_merriest
murries94118673_murries
orreries8310123orreries
overdries13310883overdries
overlies112417043overlies
overrides131411013overrides
parries93925843_parries
peeries93623023_peeries
phereses1348093phereses
poetries10315583poetries
predries112714383predries
quarries1749943quarries
queries16315873que_ries
redries83721713_redries
refries104419733_refries
retries74129073_retries
scurries102911483scurries
series64540973_se_ries
serried82513973_serried
sharpies13411233sharpies
sheenies111411543sheenies
shelties111111383shelties
sherifs13299683she_rifs
shorties11414583shorties
slurries82710413slurries
spurries102311323spurries
tarries73324263_tarries
terrier73414963_terrier
terriers84210823_terriers
terrines82117553_terrines
territs72714503_territs
theorise1137873theorise
theorises1247813theorises
theorizes2147073theorizes
therapies1447723therapies
theres96525473the_r_es
thermes126214613the_rmes
thermites1438043thermites
thermits1338513thermits
theurgies1343353theurgies
thirties1139723thirties
veeries102916893_veeries
wastries111212883wastries
waxberries2243133waxberries
wearied112911813w_earied
wearier103613283w_earier
weariest112914793w_eariest
wedgies123910213w_edgies
weeklies1534913weeklies
weenies102915093w_eenies
weepies122811743w_eepies
weirdies12255783weirdies
wellies103719073w_ellies
whammies18265513whammies
wharves16457133wh_arves
wheedles1534643wheedles
wheelie1336193wheelie_
wheeples1634743wheeples
wheezes22306803whe_ezes
wheezier2333343wheezier
wheeziest2443663wheeziest
whelkier1833253whelkier
whelkiest1943963whelkiest
where117019423whe_r_e_
whereas13448903whe_reas
whereases1545673whereases
wherein13216593wherei_n
wherever1743823wherever
wherry15477333wherr__y
wherrying1952993wherrying
wherve15568113whe_rve_
whimsies1635193whimsies
whinnies14237273whinnies
whirlier14175293whirlier
whirliest15216043whirliest
whirred14386933whirr_ed
whirring15286283whirring
whirrs12408593whirr__s
whiskies1835953whiskies
whities133113253wh_ities
whoopies16267373whoopies
whores125617103wh_or_es
whortles14306743whortles
wienies102213683wie_nies
wineries112316533wineries
worried11308693w_orried
worrier102311683w_orrier
worriers11257813w_orriers
worrits10258683w_orrits
wries85827743w___ries

Search took 7 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.436409841.7
2DLD Change Limit1461622056.25023385.9
3Display Results2052050.0962135.4
 (SQL Overall)1786912056.78226347.8
 
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.