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

95 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
tunicate10331004(None) 
tunicae9328141tunica_e
tunicated12257491tunicated
tunicates11268741tunicates
muricate12311112muricate
sonicate10310932sonicate
suricate10312612suricate
truncate1046282trun_cate
tunica8379812tunica__
tunicle9308032tunic_le
abdicate1348903abdicate
aduncate1145573adun_cate
animate91617213_animate
auspicate1345743auspicate
bunkmate1643963bunkmate
busticate1357753busticate
cuneate9311723cun_eate
dedicate12312803dedicate
delicate11315493delicate
dunite7315013duni__te
duplicate1447003duplicate
enunciate1145743enunciate
fornicate1446083fornicate
fumigate1446153fumigate
funicle12237483funic_le
furcate12310453fu_rcate
gunite7414403guni__te
indicate11313353indicate
jubilate1746553jubilate
juniorate1644013juniorate
loricate10310663loricate
lubricate1346443lubricate
lunate6316043lun__ate
lunulate838253lunulate
medicate13513243medicate
meniscate1346213meniscate
muriate9313363muri_ate
muricated1448243muricated
musicale1247343musicale
mutilate10312273mutilate
nictate9310223__nictate
nidate7313783__nidate
plicate11314513_plicate
pumicite1446813pumicite
punctate1246473punctate
quinate16511573qu_inate
radicate11412873radicate
rubricate1346483rubricate
ruinate7312833ru_inate
ruminate10511473ruminate
runagate944293runagate
runcinate1146473runcinate
rusticate1149033rusticate
sanitate8612043sanitate
silicate10312623silicate
sonicated1248453sonicated
sonicates11410383sonicates
spicate113214193_spicate
sulcate9314423su_lcate
supinate10310313supinate
suricates11311743suricates
syndicate1544513syndicate
tannate71813523tan_nate
teniae64517353teni_a_e
thecate123210023t_hecate
tinplate1047743tinplate
titivate1146803titivate
toccate1138773t_occate
tonicity1348543tonicity
truncated1244583trun_cated
truncates1145843trun_cates
tubate82813173tu__bate
tubulate1038273tubulate
tungstate1042873tungstate
tunic74018223tunic___
tunicles10217133tunicles
tunics83811263tunic__s
tunnage8166373tun_nage
turbinate1146673turbinate
uncage93014873_un_cage
uncake122813523_un_cake
uncase83817433_un_case
unciae83215313_uncia_e
uncinate10312393_uncinate
uncrate9415953_uncrate
uncute82912133_un_cute
uniface1236953_uniface
unitage838993_unitage
unite54828383_uni__te
unstate71916213_unstate
urinate7315363_urinate
urticate1049863urticate
vesicate131210053vesicate
vindicate1546353vindicate
zincate1838533zin_cate

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 Limit146162957.01620832.7
3Display Results95950.0303166.7
 (SQL Overall)178691957.45223978.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.