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

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
tachinid144624(None) 
tachinids1544041tachinids
machined1637302machined
tahini939892ta_hini_
tahinis1048012ta_hinis
aching126521973_achin_g
acini75718983_ac_ini_
acinic104713543_ac_inic
aclinic11188973_aclinic
actinia91710853_actinia
actinic111810553_actinic
actinide11199213_actinide
actinoid1148013_actinoid
arachnid1455593arach_nid
baching156017753bachin_g
bauhinia1343293bauhinia
caching156317503cachin_g
chined125620063__chined
echini114710433_echini_
echinoid1445993_echinoid
kachina1637663kachin_a
kachinas1736343kachinas
machine14313493machin_e
machines15312893machines
machining1746933machining
machinist1648483machinist
pachinko1942303pachinko
pachisi14329523pachisi_
pachisis15268823pachisis
rachitic1547593rachitic
rachitis1348353rachitis
tabanid1047333ta_banid
tachism1478873tachi_sm
tachisme1554693tachisme
tachisms1567143tachisms
tachist12613293tachi_st
tachiste1356213tachiste
tachists1348183tachists
tachyonic1943273tachyonic
tackified1944713tackified
tacking144421483tackin_g
tacrine9311293tacrin_e
tacrines10310563tacrines
tankini11338923tankini_
tankinis12245913tankinis
teaching143612603teachin_g
teachings15296553teachings
technic1496903tech_nic
tracheid1437583trach_eid
vaccinia1543363vaccinia

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.406440125.6
2DLD Change Limit146162507.03020791.2
3Display Results50500.0331515.2
 (SQL Overall)178691507.46923924.4
 
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.