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

101 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
tunicae932814(None) 
tunica8379811tunica_
tunicate103310041tunicate
tunicle9308031tunicle
funicle12237482funicle
teniae64517352teni_ae
tunic74018222tunic__
tunicated12257492tunicated
tunicates11268742tunicates
tunicles10217132tunicles
tunics83811262tunic_s
unciae83215312_unciae
arnica8310443arnica_
arnicas939543arnicas
auricle9139813auricle
cnidae978143_cnidae
conical11316203conical
cubical1338463cubical
cubicle1337003cubicle
curiae84518373curi_ae
cuticle1138233cuticle
cynical1437873cynical
dunce86319263dun_c_e
duncical1345213duncical
dunite7315013duni_te
ethnical1346363ethnical
finical1239693finical
funicles13246833funicles
gunite7414403guni_te
juice14311323ju_ic_e
loricae938253loricae
lunulae735613lunulae
minicab13177163minicab
minicam131110053minicam
minicar11109313minicar
muricate12311113muricate
muscae10410673mu_scae
musical1139553musical
musicale1247343musicale
nicad8312613__nicad
nice65534713__nic_e
niche105016793__niche
nuncle839363nun_cle
ounce77019933oun_c_e
panicle11129983panicle
plicae10410953_plicae
pumice1238223pumic_e
quiche2057903qu_iche
quince173910133quinc_e
runic73615773runic__
sanicle91210263sanicle
sonicate10310933sonicate
spicae104313703_spicae
subniche1554253subniche
sundae7312873sun_dae
suricate10312613suricate
taeniae739083taeni_ae
taxicab1843413taxicab
tenace82715693tenac_e
tenia55324483teni_a_
tenias64720073teni_as
thecae11299653t_hecae
thrice114311573thric_e
tibiae838483tibi_ae
tical76021493t__ical
tincal83913363tin_cal
tonic74727653tonic__
tonics83617863tonic_s
topical1139953topical
toxical1637643toxical
trice75127493t_ric_e
truncate1046283trun_cate
tubae74716643tu__bae
tuille63012643tu_ille
tuna45127843tun__a_
tunable92511313tunable
tunas54224123tun__as
tundra736423tundra_
tundras857113tundras
tune45635863tun___e
tuning74016843tuni_ng
tunnage8166373tunnage
turrical1046203turrical
tusche1136783tu_sche
twice104711123t_wic_e
typical1436343typical
uncage93014873_un_cage
uncake122813523_un_cake
uncap9312283_un_cap
uncase83817433_un_case
uncia75015163_uncia_
uncial83715223_uncial
uncle7317053_un_cle
uniface1236953_uniface
unique1558163_unique
unitage838993_unitage
unite54828383_uni_te
unlace82215173_unlace
utricle937913utricle
vesicae12177703vesicae
vomicae1445303vomicae

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.406440125.6
2DLD Change Limit1340271017.01619103.1
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.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.