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

101 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
wouldst113406(None) 
couldst1037041couldst
wouldest1235481wouldest
couldest1148352couldest
foulest10313312foulest
moulds94910992moulds_
shouldst1243392shouldst
woalds10427582woalds_
wolds95420182wo_lds_
worlds10568732worlds_
would95513152would__
wounds103811632wounds_
auldest839893_auldest
boldest102613063bo_ldest
bolds85825283bo_lds_
boulder103411343boulder
boules84925973boules_
bounds94415803bounds_
caulds95512383caulds_
coldest102514763co_ldest
colds85726973co_lds_
coolest9318643coolest
could86517713could__
coulis84018763coulis_
doulas75114993doulas_
dourest8312943dourest
faulds10438963faulds_
folds95221693fo_lds_
fouls87221433foul_s_
founds104814193founds_
goldest92411173go_ldest
golds75421313go_lds_
goulash1164273goulash
gourds8108253gourds_
holds94623243ho_lds_
holist94723213ho_list
hounds104413133hounds_
joules134116823joules_
joust125122293jou__st
loudest839933loudest
molds85324833mo_lds_
molest85022743mo_lest
mould86015753mould__
moulded11348063moulded
moulder10389803moulder
mouldiest1234723mouldiest
mouldy12437413mould_y
moult74728723moul__t
moults84713703moults_
mounds93915133mounds_
noblest93613563noblest
oblast8613663_oblast
oculist9310883oculist
oldest72114093_o_ldest
olds55926583_o_lds_
ouds56430113_ou_ds_
oust46747443_ou__st
outlast71015443_outlast
pollist9816603pollist
populist1248203populist
poult76928873poul__t
poults84613483poults_
pounds93714383pounds_
roundest9310473roundest
rounds73615623rounds_
roust55532063rou__st
shouldest1344143shouldest
souls55127363soul_s_
soundest9510973soundest
sounds74616183sounds_
sourest7515713sourest
swounds11405643swounds_
tourist7313203tourist
volost9412643vo_lost
wauls86120553waul_s_
wealds10459103wealds_
welds94719163w_elds_
whilst1239143whil_st
wields10469623wields_
wildest113311273w_ildest
wilds94818213w_ilds_
woads94818443wo_ads_
woald94813073woald__
wofullest1543243wofullest
wold85429073wo_ld__
wolfs116214163wo_lfs_
woodlot1147023woodlot
woods95723033wo_ods_
woodsy13505923wo_odsy
woolhat1346043woolhat
wooliest113011643wooliest
wools84421463wool_s_
words95425073wo_rds_
world96915363world__
worldly1433993worldly
worst86330133wo__rst
wost76544363wo___st
wound94414213wound__
wounded12329763wounded
wurst85122993w_u_rst
zounds164310173zounds_

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.453394461.4
2DLD Change Limit1340271016.95319276.1
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.43924020.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.