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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
tacitness113487(None) 
acidness1136722_acidness
laciness102112552laci_ness
licitness1145372licitness
raciness102413452raci_ness
tacitnesses1336322tacitnesses
tackiness1557692tackiness
tactless10288462tac_tless
tartiness92112052tartiness
tartness82210132ta_rtness
tastiness92311142tastiness
tattiness9239412tattiness
tautness8217182ta_utness
achiness1339703_achiness
acridness1245073_acridness
actress948533_ac_tress
acuteness1145863_acuteness
aptness9268573_a_ptness
aridness939223_aridness
artiness81615403_artiness
avidness1246113_avidness
battiness11239843battiness
caginess11310303cagi_ness
cakiness1449553caki_ness
cattiness112310633cattiness
dacites101114593dacit_e_s
daftness1235533da_ftness
earwitness1342623earwitness
easiness8313043easi_ness
exactness1843623exac_tness
facileness1545503facileness
faintness1235833faintness
fairness1136563fa_irness
fanciness1437673fanci_ness
fastness11238763fa_stness
fatness103311293fa__tness
fattiness12239373fattiness
fitness10299393__fitness
gaminess112911063gami_ness
gastness9278473ga_stness
gauntness1044203gauntness
hastiness122410883hastiness
haziness20248513hazi_ness
iciness938863_ici_ness
intactness1244313intac_tness
laziness17239983lazi_ness
lucidness1244313lucidness
maltiness112910573maltiness
matiness102114753mati_ness
maziness19239543mazi_ness
nastiness92310573nastiness
nattiness9239333nattiness
packness1636933pac_kness
pastiness112312353pastiness
pastness102510503pa_stness
patness92912283pa__tness
placidness1553303placidness
rabidness12145263rabidness
rancidness1344223rancidness
rapidness12155473rapidness
raptness1046733ra_ptness
saltiness93312113saltiness
saltness82610243sa_ltness
sauciness1138043sauci_ness
scantness1135733scantness
spaciness1337083spaci_ness
staginess1038753stagi_ness
staidness1037033sta_idness
straitness1046293straitness
strictness1245643strictness
tackless14419483tac_kless
tacrines10310563tacrine_s
tailless8239083ta_illess
taintless935733taintless
talkiness1356913talkiness
tallness837103ta_llness
tameness102411253ta_meness
tanginess10239283tanginess
tardiness10229913tardiness
tarriness9229243tarriness
tawniness1245123tawniness
taxites1449673taxit_e_s
teariness9310633teari_ness
tepidness1244343tepidness
testiness9209753testiness
thickness1844443thickness
thinness11277163t_hinness
tidiness938793tidi_ness
tightness1386603tightness
timidness1244623timidness
tininess8310633tini_ness
titaness836723t__itaness
traitress944403traitress
trigness968403t_rigness
trimness1067563t_rimness
triteness9310363t_riteness
tumidness1243843tumidness
unfitness1244843unfitness
vacantness1562513vacantness
vainness1136063va_inness
validness13125363validness
vapidness15144423vapidness
vastness11257293va_stness
wackiness1836523wackiness
waitress1135223wa_itress
wariness11313213wari_ness
waviness1437723wavi_ness
waxiness1836723waxi_ness
witness103010013__witness
zaniness1738663zani_ness

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411106.31323545.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.76526414.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.