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

138 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
lunatic93875(None) 
lunatics1045471lunatics
agnatic10310972agnatic
cuneatic1245852cuneatic
dunitic1048142dunitic
enatic8317562_enatic
fanatic12610702fanatic
lentic83515742len_tic
luetic8310382lu_etic
lunate6316042lunat_e
lunated8310822lunated
lunation8311922lunation
quantic18279062quantic
uratic83016362_uratic
venatic12311522venatic
acmatic13311703acmatic
antic75728863_an_tic
aplanatic1344903aplanatic
aquatic1838113aquatic
astatic9514193astatic
augitic1038283augitic
auntie64317703aun_tie
auxetic1637143auxetic
aviatic1239243aviatic
bustic101012693bu_stic
cantic103920543can_tic
climatic1448733climatic
comatic131816943comatic
cultic105111903cu_ltic
dynamic1545813dynamic
dynastic1445853dynastic
ectatic11310123ectatic
elenctic1245883elenctic
erratic9311123erratic
eustatic1047343eustatic
fanatics1367183fanatics
frantic12310373frantic
fumaric1446313fumaric
fundic12389083fun_dic
fungic12387813fun_gic
fustic11910633fu_stic
genetic101211783genetic
gnathic1344843_gnathic
gonadic1177213gonadic
hematic141816753hematic
hepatic141712773hepatic
ignatia846133ignatia
kenotic1359713kenotic
kinetic13209173kinetic
lactic10713493l_actic
laic65931563l__a_ic
lanai5319573lana_i_
lanais6316793lana_is
lanate6421263lanat_e
lanated8313203lanated
lati46438273l__ati_
lentil64315393len_til
leucitic1245233leucitic
leukotic1444523leukotic
lignitic1146393lignitic
limnetic1255583limnetic
linac7315413lina__c
litotic939243litotic
lotic76420673l__otic
lubric1097983lu_bric
ludic82912803lu__dic
luetics937323lu_etics
luna46229853luna___
lunacies1038013lunacies
lunacy1136843luna_cy
lunar57017313luna__r
lunarian847293lunarian
lunars65012813luna_rs
lunas55025013luna__s
lunately1144543lunately
lunations9310723lunations
lunet56835423lunet__
lunets66914763lunet_s
lunette737483lunette
lungi65516053lun_gi_
lungis77113023lun_gis
lungyi10525093lungyi_
lungyis11294103lungyis
lunt46148843lun_t__
lunted74517523lun_ted
lunting83817743lun_ting
lunts55826903lun_t_s
luxate1338083luxat_e
luxated1535713luxated
luxates1436973luxates
luxating1645613luxating
luxation1538233luxation
lytic104513033l__ytic
mantic104120903man_tic
monadic1268883monadic
monastic1249863monastic
muntin82915183mun_tin
naric76824173__naric
nastic82915973__nastic
nematic111714003nematic
neumatic1258533neumatic
nunatak1142673nunatak
ontic74418573_on_tic
osmatic11179993osmatic
phatic133014413_phatic
piratic11314293piratic
psoatic1139303psoatic
punditic1364983punditic
puranic11410483puranic
quantics19276833quantics
quartic18258473quartic
quintic18308883quintic
rubati8299693rubati_
runic73615773run__ic
rustic8712673ru_stic
sciatic11910173sciatic
sematic111716883sematic
somatic111916473somatic
sonantic1048273sonantic
static83118683_static
synaptic1546283synaptic
tonetic9313433tonetic
tsunamic1242403tsunamic
tungstic1143843tungstic
tunic74018223tun__ic
unai44824783_una_i_
unais53420773_una_is
unakin10310963_unakin
unchic1338643_unchic
unific1137463_unific
unstick1338123_unstick
untie54425493_un_tie
until53517743_un_til
uranic82315183_uranic
uretic82914353_uretic
vanadic1336743vanadic
vatic10316423__vatic
viatic11311453_viatic

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271386.47020715.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.92225814.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.