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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
lauded8381215(None) 
laded74232611la_ded
landed84619241landed
larded84319091larded
lauder73815011lauder
added84918432_added
aided75828932_aided
alluded9327092alluded
aludel747852aludel
audad71511382_audad
balded105417512balded
banded105223172banded
barded105426422barded
belauded1244792belauded
bladed104717762bla_ded
carded105424902carded
caudad10157672caudad
caudex1636392caudex
caused95117042caused
cladded12356922cladded
clouded11348832clouded
daubed104611782daubed
dauted84114932dauted
duded84417132_duded
eluded84612772eluded
exuded15317682exuded
faded105025242fa_ded
farded114518952farded
feuded114010002feuded
gadded103913172gadded
gauged94713472gauged
gaumed104610322gaumed
gladded11357452gladded
haded105227622ha_ded
handed114919982handed
hauled104415212hauled
illuded9305762illuded
jaded144417032ja_ded
jauked18489012jauked
jauped16457902jauped
laced87132642la_ced
lacked135324652lacked
ladder84617622ladder
lade56345982la_de_
laden65022192la_den
lader65633722la_der
lades65141272la_des
ladled85013482ladled
lagged95520132lagged
laired75216812laired
laked105731122la_ked
lalled74218752lalled
lambed115614782lambed
lamed85235292la_med
lammed113915622lammed
lamped114017542lamped
lanced93717722lanced
lander74028482lander
lapped114320032lapped
lapsed94712582lapsed
larder73720972larder
larked114519472larked
lased65132342la_sed
lashed105625212lashed
lasted74323602lasted
lated65240672la_ted
lathed104718452lathed
laud56527722lau__d
lauders84012892lauders
lauds65618482laud_s
laughed1235892laughed
launder8309142launder
laurel649032laurel
laved95028592la_ved
lawed96028322la_wed
layed95127382la_yed
lazed154925842la_zed
lazied164610652lazied
leaded84221542leaded
leudes75314092leudes
lidded93410242lidded
loaded84616872loaded
loided83414022loided
lorded84916732lorded
louden73711792louden
louder74414602louder
louped95316382louped
loured74617402loured
loused74822912loused
louted74920692louted
lubed85319892l_ubed
lude55331642l_ude_
ludes65728852l_udes
luged74019092l_uged
lured65427492l_ured
luted64826142l_uted
madded113513552madded
mauled94817822mauled
padded114113502padded
paused95114962paused
plaided11409642plaided
radded94716492radded
raided85017702raided
sanded84920612sanded
sauced93913302sauced
sauted74119602sauted
tauted75317112tauted
wadded124014172wadded
waded106024752wa_ded
warded115021042warded
wauked144210572wauked
wauled104713962wauled
yarded114714022yarded
yauped12408332yauped

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511142.45333653.1
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.59668833.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.