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

57 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
leachate134744(None) 
leachates1446661leachates
lactate9312702l_actate
leachable16136442leachable
acuate8315633__acuate
baccate131011263_baccate
bleachable1943383bleachable
brachiate1646873brachiate
deaerate9314173deaerate
dealate83617843dea_late
emaciate1248753emaciate
enchase1239463_enchase
evacuate13217303evacuate
exarchate2144453exarchate
glaciate1168083glaciate
headgate1346483headgate
labiate91313573l_abiate
lacerate102214713l_acerate
lactase937963l_actase
lactated1138873l_actated
lactates10311233l_actates
lacunate10128963l_acunate
lanate6421263l_a_nate
leach105422523leach___
leached133715043leach_ed
leacher124014843leach_er
leachers133712813leachers
leaches123319343leach_es
leachier1337253leachier
leaching143012833leaching
leachy14419733leach__y
leafage1194573lea_fage
leakage1235003lea_kage
lechwe1435113le_ch_we
legate72917453le__gate
leucite937753leuc_ite
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
locate83919843l_oc_ate
machete14310883_machete
moschate1546593moschate
peacoat11412913peacoat_
peacoats1247833peacoats
pectate112214693pe_ctate
placate11312433plac_ate
reachable16129653reachable
recrate92621663re_crate
saccate111311763_saccate
seatmate1048573seatmate
teacake1335453teac_ake
teachable16137603teachable
teammate1245613teammate
tracheate1448233tracheate
trachyte1645943trachyte
tractate10411003tractate
vacate11314553_vac_ate

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 Filter1786911461620.440406115.9
2DLD Change Limit146162577.34319904.9
3Display Results57570.0163562.5
 (SQL Overall)178691577.79922912.0
 
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.