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

109 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
leotard84619(None) 
leopard1045291leopard
leotards945301leotards
dotard839052_dotard
jeopard1744112jeopard
leeward1135782leeward
leftward1562732leftward
leopards1144752leopards
leotarded1142782leotarded
petard95013802pe_tard
retard75018932re_tard
aboard9312613abo_ard
bastard103012423bastard
beard86024963be__ard
becoward1644763becoward
bedward1497473bedward
beeyard1335523beeyard
board85523003_bo_ard
boyard125411283_boyard
bustard10389723bustard
centare93113703centare
costard104113353costard
coward12411673_coward
custard10389973custard
dastard9279703dastard
debeard1137353debeard
deodand1035713deodand
deodar837713deodar_
deodara945243deodara
deodars937623deodars
dotards937253_dotards
echard1249223_echard
feodary1444713feodary
froward1436673froward
heard95222753he__ard
hectare1238463hectare
hektare1435503hektare
heptad1237273hepta_d
hoard94918313_ho_ard
holard10410573_holard
jeopards1843683jeopards
jeopardy2142233jeopardy
keycard1743663keycard
lactary1237853lactary
laggard10347623laggard
laniard868523laniard
lanyard1167293lanyard
lard56742003l___ard
lead56038853le__a_d
lear47045953le__ar_
learn55322663le__arn
lears55938733le__ars
leary85927383le__ary
lectern937033lectern
lector83514993lector_
lectors93415773lectors
lecture9149523lecture
lectured11127233lectured
leeboard1145433leeboard
leewards1244983leewards
lefter93613433lefter_
leftwards1652453leftwards
legated92513983legated
lekvar1333043lekvar_
lekvars1432693lekvars
lentando943603lentando
lentoid8310683lentoid
lepta75714393lepta__
letted74118543le_tted
letter63722583letter_
lettered92910783lettered
letters73819853letters
liard65418593l__iard
lizard16369233l_izard
load56730603l_o_a_d
lobar7313013l_obar_
looted74421113loot_ed
looter64222323looter_
looters74419163looters
lord55032083l_o__rd
lota47233503l_ota__
lotah85315853l_ota_h
lotahs9479873l_otahs
lotas55926303l_ota_s
lotted74222403l_otted
lyard95113213l__yard
mustard10359533mustard
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
notary92310713_notary
pentad9313763penta_d
petards104311153pe_tards
reboard10310763reboard
regard85215773re_gard
reheard11309023reheard
restart7320033restart
retards85015003re_tards
reward106017643re_ward
reynard1135123reynard
ritard74812083_ritard
rotary92411303_rotary
seaward1148183seaward
sectary1238273sectary
tetrad73612053te_trad
toward10311063_toward
unitard838003unitard
votary12248333_votary
westward1543823westward

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.406440125.6
2DLD Change Limit1340271097.25018486.5
3Display Results1091090.0303633.3
 (SQL Overall)1786911097.68623248.9
 
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.