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 “weald” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
weald9561502(None) 
weal75838681weal_
wealds10459101wealds
weals85428741weals
weld84727731we_ld
woald94813071woald
bald76432902_bald
bead75937922bea_d
beard86024962beard
dead65434242dea_d
deal56347412deal_
deals65435342deals
dealt65234282dealt
eld46733792_e_ld
feal713940422feal_
geld65828432ge_ld
head87137172hea_d
heal75645692heal_
healed105121442healed
heals85733452heals
heard95222752heard
held85330402he_ld
herald10311342herald
lead56038852lea_d
leal46043272leal_
mead75531602mea_d
meal65643172meal_
meals75933372meals
mealy104422182mealy
meld75830472me_ld
peal68648102peal_
pealed95322812pealed
peals75235492peals
read55942532rea_d
readd74617132readd
real45750292real_
realm75621622realm
reals55038652reals
scald84818122scald
seal45654372seal_
sealed74328362sealed
seals54839692seals
skald104210172skald
teal45546502teal_
teals56234132teals
veal76936812veal_
vealed103916322vealed
veals84926192veals
vealy115817772vealy
veld85323202ve_ld
wad77053892w_a_d
wale74546432w_ale
waled94330992w_aled
walk115625612w_alk
wall76236102w_all
waly105830902w_aly
wand85833882w_and
ward86542252w_ard
weak117126302wea_k
weakly1636482weakly
wealth12379222wealth
wean75734352wea_n
weaned103816152weaned
weans85326742weans
wear75836722wea_r
wears86030302wears
weary115620612weary
weave115218532weave
weaved133913482weaved
wed75843622we__d
weed85637512we_ed
weel75834082weel_
weird95111282weird
welds94719162we_lds
well75832042we_ll
welled103820212welled
wells85426192wells
welly114620012welly
welt75547862we_lt
wend85330452we_nd
wetly114511712wetly
whale115517432whale
whaled134612032whaled
wheal115716182wheal_
wheals124512522wheals
wield95213912wield
wild85126512w_ild
woad85523942woa_d
woalds10427582woalds
wold85429072w_old
world96915362world
would95513152would
yald86920612_yald
yeld811423872ye_ld
zeal135530332zeal_
zeals145320852zeals

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800961.46636698.5
3Display Results96960.0332909.1
 (SQL Overall)178691961.81298615.3
 
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.