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

195 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
frantic1231036(None) 
antic75728862__antic
cantic103920542_cantic
drastic10310872drastic
fanatic12610692f_anatic
fanfic1436312f_anfic
fracti1139962fracti_
franc104615412fran__c
franticly1744012franticly
frenetic1346292frenetic
granitic1168622granitic
mantic104120902_mantic
practic13312242practic
quantic18279062quantic
uranic82315182uran_ic
uranitic10148682uranitic
uratic83016352ura_tic
agnatic10310973agnatic
anti45536363__anti_
antick124814583__antick
antics84621453__antics
antis55033313__antis
apractic1448303apractic
arabic10312733ara_bic
araneid8310803araneid
arctic10313513ar_ctic
argentic1149023argentic
argotic10310283argotic
atactic11410083atactic
attic75618353__attic
barytic1437823barytic
biontic1148333biontic
brant74742173brant__
brantail1046893brantail
brants85723053brant_s
brattice1245693brattice
chaotic14310043chaotic
clastic113013963clastic
crania82418433cran_ia
cretic102816283cr_etic
critic103616813cr_itic
cryptic1646153cryptic
cyanic133110773cyan_ic
cyanitic1566323cyanitic
cyanotic1546623cyanotic
deontic1038883deontic
dramatic1369423dramatic
elastic93013393elastic
enatic8317563ena_tic
ergastic11106623ergastic
ergotic1049723ergotic
eristic9814093eristic
erotic82620273er_otic
erratic9311113erratic
fabric1337833f_abric
fanatics1367183f_anatics
fanfics1535173f_anfics
fantail10310233f_antail
fantod102010033f_antod
fantom112110803f_antom
faradaic1443653faradaic
faradic1337693faradic
ferritic1347073ferritic
fistic11812573f_istic
forensic1344943forensic
fractal1237623fractal
fracted1339373fracted
fraction1359483fraction
fractur12135563fractur
fractus12146593fractus
frail85220213fra__il
fraktur14153033fraktur
francium1545623francium
francize2246853francize
francs114112193fran_cs
frank124417513fran__k
franked153610053franked
franker143510183franker
franking164310863franking
franklin15104603franklin
frankly17315633frankly
franks134912733fran_ks
frat75648543fra_t__
frater94520593fra_ter
frats86829673fra_t_s
frazil1847223fra_zil
frenetics1444603frenetics
frolic1149203fr_olic
front85029223front__
frontal1038363frontal
fronted114011273fronted
fronter103611583fronter
frontes104214163frontes
frontier1147313frontier
fronting12310443fronting
fronton1037203fronton
fronts94415793front_s
fundic12389083f_undic
fungic12387813f_ungic
fustic11910633f_ustic
gerontic1147963gerontic
gigantic1244303gigantic
granita82111303granita
granite82017083granite
grannie8310353grannie
grant64840023grant__
granted94715103granted
grantee83217133grantee
granter84117133granter
granting103514523granting
grantor84010933grantor
grants73722473grant_s
graphic1537353graphic
gratin74520583gra_tin
gratis74819243gra_tis
haptic13511893_haptic
identic1038043identic
irenic8311103iren_ic
iritic83213823ir_itic
ironic8313773iron_ic
karstic1357983karstic
lactic10713493_lactic
lentic83515743_lentic
lunatic938753lunatic
manic94629443_man_ic
mantid93820383_mantid
mantis83926033_mantis
mantric11311343_mantric
mastic103119173_mastic
nastic82915973_nastic
ontic74418573__ontic
orectic1138823orectic
organic1038313organ_ic
orgastic11116213orgastic
panic93923903_pan_ic
pantie84326473_pantie
paranoic1249833paranoic
paretic113016673paretic
parotic112518043parotic
pedantic1346583pedantic
phatic133014413pha_tic
pianic103714123pian_ic
piratic11314293pira_tic
plastic112815063plastic
practice1438733practice
prentice121012353prentice
puranic11410483puran_ic
quantics19276833quantics
quartic18258473quartic
quintic18308883quintic
rabic93817403_ra_bic
ramtil8311023_ramtil
rancid9513863_rancid
rani46640113_ran_i_
ranid66429333_ran_id
ranis55235833_ran_is
rant45864683_rant__
ranted74324703_ranted
ranter63826823_ranter
ranting84025413_ranting
rants55935343_rant_s
ratio55227583_ra_tio
rhotic112711233_rhotic
romantic1249233romantic
runic73615773_run_ic
rustic8712673_rustic
santir6315253_santir
scandic1237003scandic
semantic1249553semantic
shanti94014093shanti_
shantih13309643shantih
shantis103313103shantis
sonantic1048273sonantic
spastic11310383spastic
stannic936663stannic
static83118683sta_tic
strontic1048103strontic
tactic10612753_tactic
tannic82811473_tannic
tantric939583_tantric
traffic1544733traffic
tragic93811543tra_gic
transit7317163transit
tryptic1446003tryptic
tyrannic1344143tyrannic
uraemic1156543uraemic
uralitic10158453uralitic
urania62516123uran_ia
uranite72515693uranite
uranylic1343183uranylic
uretic82914353ur_etic
vatic10316423_va_tic
venatic12311523venatic
viatic11311453via_tic
xanthic1945863_xanthic

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.410435831.7
2DLD Change Limit1340271956.25021444.3
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.72026590.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.