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

51 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
technics158546(None) 
technic1496901technic_
atechnic1554402atechnic_
ethnics1236262_ethnics
mechanics1845982mechanics
techies12513602tech_ies
technical1646052technical
technicals1753952technicals
technos1236182techn_os
tectonics1345952tectonics
tetanics10127372tetanics
chics123920943__ch_ics
conics103920593__conics
cynics13377363__cynics
ebonics1137193_ebonics
echinus1236203_echinus
echoic1339043_echoic_
etchings14396293etchings
ethics11169283_eth_ics
ethnic1148853_ethnic_
hedonics1445903hedonics
lychnis1544383lychni_s
mechanic1747613mechanic_
melanics1237733melanics
picnics13297343pic_nics
scenics1137773_scenics
tachinids1544043tachinids
tactics1149323tac_tics
teachings15296553teachings
techie11511723tech_i_e
techier1269243tech_ier
techiest1359833tech_iest
techily1537123tech_ily
technician1753163technician
technicians1852653technicians
technique2361943technique
techniques2481803techniques
techno1135953techn__o
techs106915833tech___s
tectonic1248453tectonic_
tectrices1346253tectrices
tenias64720073te__nias
tennies73017973te_nnies
tennis64015303te_nni_s
tetanic9810133tetanic_
tetanies8513553tetanies
tonics83617863t__onics
trochaics1645063trochaics
tunics83811263t__unics
zechins21137123zech_ins
zootechnics2761413zootechnics

Search took 7 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 Limit146162516.48322545.4
3Display Results51510.0163187.5
 (SQL Overall)178691516.90525878.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.