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

86 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
technic149690(None) 
atechnic1554401atechnic
technics1585461technics
echoic1339042_echoic
ethnic1148852_ethnic
mechanic1747612mechanic
techie11511722tech_ie
technical1646052technical
techno1135952techn_o
technos1236182technos
tectonic1248452tectonic
tetanic9810132tetanic
acinic104713543_acinic
aeonic83517043ae_onic
anechoic1545373anechoic
archaic1438823archaic
chic115925203__ch_ic
conic95329793__conic
cynic124712423__cynic
demonic12311223demonic
ecesic10369223_ecesic
eching126315563_eching
echini114710433_echini
edenic9310223_edenic
etching134511843etching
ethic101511223_eth_ic
ethnics1236263_ethnics
exonic153211413_exonic
genic85119393ge__nic
hectic132311513hec_tic
hedonic1339043hedonic
iconic10411593_iconic
ketonic1349923ketonic
laconic1139883laconic
leching134613653leching
lychnis1544383lychnis
mechanics1845983mechanics
melanic11310403melanic
mesonic11310093mesonic
nephric1446213nephric
obconic1346353obconic
oceanic1146163oceanic
peching154513903peching
pectic122913873pec_tic
picnic123410263pic_nic
scenic10510513_scenic
selenic9410663selenic
stichic1446243stich_ic
strychnic1952163strychnic
tachinid1446243tachinid
tachyonic1943273tachyonic
tactic10612753tac_tic
tannic82811473t_annic
teaching143612603teaching
tech95925443tech___
teched124014433tech_ed
techier1269243techier
techies12513603techies
techily1537123techily
technicals1753953technicals
technician1753163technician
technique2361943technique
techs106915833tech__s
techy135612013tech__y
tectonics1345943tectonics
tectrix1644263tectrix
telic76019823te__lic
telomic1147603telomic
telsonic1045993telsonic
tenia55324483te__nia
tennis64015303te_nnis
terbic10410963te_rbic
terebic1137983terebic
terpenic1247213terpenic
tetanics10127373tetanics
thionic1238883thionic
titanic968553titanic
tonic74727653t__onic
trochaic1546943trochaic
tunic74018223t__unic
typhonic1847173typhonic
tyronic1239313tyronic
unchic1338643unch_ic
xenic144114643xe__nic
zechin20137703zech_in
zechins21137123zechins

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 Filter1786911340270.233766914.2
2DLD Change Limit134027867.44018014.4
3Display Results86860.0461869.6
 (SQL Overall)178691867.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.