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

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

92 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
leopard104529(None) 
jeopard1744111jeopard
leopards1144751leopards
leotard846191leotard
jeopards1843682jeopards
jeopardy2142232jeopardy
leeward1135782leeward
leotards945302leotards
aboard9312613abo_ard
beard86024963be__ard
becoward1644763becoward
bedward1497473bedward
beeyard1335523beeyard
board85523003_bo_ard
boyard125411283_boyard
coward12411673_coward
debeard1137353debeard
deodand1035713deodand
deodar837713deodar_
deodara945243deodara
deodars937623deodars
depart94720563de_part
dotard839053_dotard
echard1249223_echard
eloped95914143elop_ed
eloper85414153eloper_
elopers95112943elopers
expand16236573_expand
feodary1444713feodary
froward1436673froward
heard95222753he__ard
hoard94918313_ho_ard
holard10410573_holard
jeoparded2042053jeoparded
keycard1743663keycard
keypad1633823keypa_d
laggard10347623laggard
lampad114510033lampa_d
laniard868523laniard
lanyard1167293lanyard
lard56742003l___ard
lead56038853le__a_d
leaped94317773leap_ed
leaper88118943leaper_
leapers93716663leapers
lear47045953le__ar_
learn55322663le__arn
lears55938733le__ars
leary85927383le__ary
leeboard1145433leeboard
leewards1244983leewards
leftward1562733leftward
lekvar1333043lekvar_
lekvars1432693lekvars
lempira1144193lempira
leopardess1351593leopardess
leotarded1142783leotarded
leper74820743le_per_
lepers84817323le_pers
leporid1048153leporid
liard65418593l__iard
lizard16369233l_izard
load56730603l_o_a_d
lobar7313013l_obar_
looped95217173loop_ed
looper83817113looper_
loopers93914033loopers
loped85128333l_op_ed
loper75129233l_oper_
lopers84424143l_opers
lopped114218623l_opped
lord55032083l_o__rd
lyard95113213l__yard
pard76441323___pard
peopled1238503peopled
petard95013803pe_tard
pleopod1244823pleop_od
reboard10310763reboard
regard85215773re_gard
reheard11309023reheard
repaid94716323re_paid
repand95316063re_pand
repark123511713re_park
retard75018933re_tard
reward106017643re_ward
reynard1135123reynard
seaward1148183seaward
secpar1037923secpar_
secpars1138413secpars
teopan839353teopa_n
teopans939203teopans
toward10311063_toward

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 Filter1786911340270.406440125.6
2DLD Change Limit134027926.50020619.5
3Display Results92920.0303066.7
 (SQL Overall)178691926.93625762.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.