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

144 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
faradic133769(None) 
faradaic1443651faradaic
arabic10312732_arabic
bardic11312922bar_dic
fanatic12610692fanatic
farad95720672farad__
faraday1445632faraday
faradise12219392faradise
faradism14188372faradism
faradize21237822faradize
farads104713272farad_s
fatidic1345722fatidic
hagadic1445852hagadic
parodic122311722parodic
vanadic1336742vanadic
acidic113612133_acidic
afraid1049713afra_id
agamic113110543_agamic
agaric93513623_agaric
aggadic1254783aggadic
agravic1345883agravic
amidic114012863_amidic
anodic92813133_anodic
apraxic1846293apraxic
arabica1147283_arabica
aramid93315603_aramid
arcadia1039703_arcadia
arctic10313513_arctic
areic73219393_ar_eic
asdic83814093_a_sdic
ataraxic1743923ataraxic
atavic11189293_atavic
ataxic15169203_ataxic
balladic1345333balladic
barbaric1446363barbaric
baric96125693bar__ic
barytic1437823barytic
boracic1338723boracic
carabid12311333carabid
carabin11313213carabin
carbamic1645913carbamic
cardia9916373car_dia
cardiac1278813car_diac
cardio9915673car_dio
caryatic1548483caryatic
ceramic1339823ceramic
daric85623113dar__ic
dryadic1443623dryadic
dyadic1336093_dyadic
erratic9311113erratic
fabric1337833fa_bric
facade1238803facad_e
facades1339033facades
fanatics1367183fanatics
fanfic1436313fa_nfic
faradays1544273faradays
faradised14235913faradised
faradises13248983faradises
faradisms15256673faradisms
faradized23216313faradized
faradizer22215373faradizer
faradizes22237443faradizes
faraway1645413faraway
farci105919313far_ci_
farcie114816473far_cie
fard85639063far_d__
farded114518953far_ded
fardel104712593far_del
farding123716743far_ding
fards96629843far_d_s
fared95842343fared__
farside1138603farside
ferric1139993fer_ric
fjordic2042383fjordic
fluidic1344383fluidic
fordid113512053for_did
foredid1238503foredid
formic13310453for_mic
frail85220213f_ra_il
franc104615413f_ra_nc
frantic12310363frantic
frazil1847223f_razil
frolic1149203f_rolic
fumaric1446303fumaric
fundic12389083f_undic
gardai839663gardai_
garlic9310043gar_lic
gonadic1177213gonadic
gradin83517483_gradin
haggadic1643053haggadic
halakic1656653halakic
heraldic1445163heraldic
herdic123112303her_dic
hexadic2045413hexadic
iridic9328743_iridic
jalapic1844543jalapic
juridic1744663juridic
karmic1438113kar_mic
karstic1357983karstic
keramic1537233keramic
maenadic1344613maenadic
marasmic1446163marasmic
margaric1346053margaric
monadic1268883monadic
naric76824173nar__ic
nomadic1248023nomadic
nordic939473nor_dic
octadic1245713octadic
paladin101011773paladin
palladic1346113palladic
parade94720643parad_e
paraded114014263paraded
parader103914863parader
parades104121463parades
paradigm1446243paradigm
parading12313863parading
paradise112113873paradise
parador103311413parador
parados103816053parados
paradox17358173paradox
paramedic1645723paramedic
paranoic1249833paranoic
pardi85723953par_di_
pardie96021443par_die
paretic113016673paretic
parotic112518033parotic
piratic11314293piratic
puranic11410483puranic
pyridic15267833pyridic
rabic93817393__rabic
radii64016413__radii
radio64922493__radio
radix134414593__radix
saccadic1244173saccadic
satanic939933satanic
sporadic1345053sporadic
tartaric1047053tartaric
tetradic1145813tetradic
tornadic1144833tornadic
tragic93811543_tragic
triadic1037823triadic
uranic82315183_uranic
uratic83016353_uratic
veridic1338143veridic

Search took 9 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.1561145455.1
2DLD Change Limit1340271448.28316181.0
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.49921024.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.