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

86 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
lethe8571730(None) 
lathe85626711lathe
lethes94818081lethes
lithe84922011lithe
aether94213672aether
bathe105822882bathe
beth96629232beth_
bethel1169642bethel
beths105519222beths
blether12459912blether
blithe115810862blithe
cete64934782cet_e
clothe114712992clothe
eche97520282_eche
eth66630982_eth_
ether84518772_ether
eths76619522_eths
fete75734922fet_e
fleche14299302fleche
heth107028022heth_
heths116317782heths
jete115927252jet_e
kithe125917452kithe
kythe15509672kythe
late47560482lat_e
lath76640382lath_
lathed104718452lathed
lather95124352lather
lathes95127492lathes
lathi85417202lathi
laths86022402laths
lathy115215062lathy
latke94817092latke
latte55426302latte
lease55230262lease
leather103815782leather
leave84723722leave
lech96825442lech_
leched123716002leched
lecher113415852lecher
leches115421312leches
lechwe1435112lechwe
ledge76519462ledge
lee36068142le__e
lehr75514942le_hr
leke85527402le_ke
lense54523432lense
leone55018822leone
let36481472let__
letch105215802letch
letched133912052letched
letches124015482letches
lethal939802lethal
lethean1037092lethean
lets47147942let_s
letted74118542letted
letter63722582letter
letup73712162letup
levee84023812levee
lite47054542lit_e
lither94520952lither
litho86513782litho
litre55421462litre
loathe94211382loathe
loth76132132loth_
lotte54923852lotte
lute46341012lut_e
mete64438132met_e
meth95827842meth_
meths105320232meths
metre74821302metre
nether94014162nether
rathe85821922rathe
rete44944132ret_e
retie55735302retie
seethe93712482seethe
setae56026222setae
teethe94511312teethe
teth76327882teth_
tether93716102tether
teths85418512teths
the67436052__the
tithe85319702tithe
tythe115210452tythe
wether123315392wether
withe115220232withe

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.1101624463.6
2DLD Change Limit53800861.79629955.5
3Display Results86860.0165375.0
 (SQL Overall)178691861.92292971.4
 
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.