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

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

50 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
latchstring1710196(None) 
latchstrings18101281latchstrings
lacustrine1252833la_custrine
latching143712023latch___ing
lathering13912253lat_h_ering
lutestring1143473lut_estring
ratcheting1643783ratchet_ing
accosting1446734_accost_ing
accoutring1543624_accoutring
ancestoring1454104_ancestoring
anchoring1548324_anch_oring
attesting1036384_attest_ing
batching163712094batch___ing
blathering16107584blat_h_ering
butchering1844504butch_ering
cacheting1737154ca_chet_ing
catching163712774catch___ing
fathering161010094fat_h_ering
gathering1499464gat_h_ering
hachuring1845124ha_ch_uring
hamstring1546004ha__mstring
hatcheling1943694hatch_eling
hatchelling2052624hatchelling
hatching173312214hatch___ing
hatchling1844954hatch__ling
lackering1639374la_c_kering
lacquering2243604la_cquering
lactating1239184la_ctat_ing
laicising1245624laicis__ing
lambasting1543344lambast_ing
lasting84725244la___st_ing
lathing114315694lat_h___ing
leathering1488684leat_h_ering
lechering1538444l_ech_ering
letching143810264letch___ing
lichting14268514l_ich_t_ing
lustring9269724l___ustring
lutestrings1252114lut_estrings
matching163512394match___ing
matchmaking2552974matchmaking
matchmarking2651974matchmarking
matchstick2351704matchst_ick
patching163212754patch___ing
patchworking2751484patchworking
racheting1537794ra_chet_ing
slathering14108284slat_h_ering
watching173011174watch___ing
watchmaking2652464watchmaking
wauchting1843474wauch_t_ing
yachting1734934ya_ch_t_ing

Search took 9 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 Filter1786911488190.436409841.7
2DLD Change Limit148819508.03018532.9
3Display Results50500.0331515.2
 (SQL Overall)178691508.49921024.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.