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

64 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
lathi8541720(None) 
lath76640381lath_
lathe85626721lathe
lathis95516171lathis
laths86022401laths
lathy115215061lathy
lati46438271lat_i
ahi68040232_a_hi
altho86312602altho
bath95940082bath_
bathe105822882bathe
baths105922922baths
calathi1247592calathi
canthi11310972canthi
dashi95013112dashi
eath75735662eath_
hath105933912hath_
laari54415712laari
laith85722102laith_
lakh114919952lakh_
lakhs125210342lakhs
lanai5319572lanai
lari45839152la_ri
lash76539652lash_
lassi56316852lassi
lat37593402lat__
latch104620462latch
late47560482lat_e
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lathed104718462lathed
lather95124362lather
lathes95127502lathes
lathier10310832lathier
lathing114315692lathing
latke94817092latke
latria62313612latria
lats45962702lat_s
latte55426302latte
lattin64316222lattin
latu47934182lat_u
lethe85717302lethe
lichi104412952lichi
litai55216362litai
litchi1137892litchi
lithe84922012lithe
lithia939332lithia
lithic1139492lithic
litho86513782litho
loath84918602loath_
loathe94211382loathe
loth76132132loth_
loti46431842lot_i
math95437452math_
maths105624022maths
oath76132152oath_
oaths86117312oaths
path99134912path_
paths105521382paths
rath76037662rath_
rathe85821922rathe
sati45539332sat_i

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.313570897.8
2DLD Change Limit53800641.62333148.5
3Display Results64640.0164000.0
 (SQL Overall)178691641.95291542.5
 
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.