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 “fado” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
fado8722647(None) 
ado49146881_ado
dado67126341dado
fad77452421fad_
fade85736351fade
fados95620731fados
fads86939881fads
fano75831691fano
faro76136921faro
fido87726411fido
abo59045962_abo
ad311975042_ad_
add510132372_add
ados57633512_ados
ads49755742_ads
adz1312332872_adz
ago48845522_ago
apo511142122_apo
avo68936232_avo
azo128233392_azo
bad67763162bad_
bade75140892bade
bads77048872bads
cad67456372cad_
cade76443922cade
cadi75732192cadi
cads76144532cads
calo64936442calo
camo85731752camo
capo85829212capo
dad58456172dad_
dada66422452dada
dados75522432dados
dads67442782dads
dago65725092dago
dato56129942dato
dido66528212dido
do310155262__do
dodo66024922dodo
eddo63411812eddo
fa510148452fa__
fab87453132fa_b
fabs98635862fabs
face96140122face
fact97142542fact
faddy135511622faddy
faded105025242faded
fader94421512fader
fades94932862fades
fadge104817002fadge
fag76852362fa_g
fagot9323402fagot
fags86939122fags
fail74840242fail
fain75840562fain
fair76332522fair
fake115534942fake
fall75535312fall
falx147120782falx
fame95639392fame
fan67158862fa_n
fandom122110892fandom
fane75343572fane
fang85432562fang
fanon84619012fanon
fanos85926502fanos
fans76247372fans
far67762602fa_r
fard85639062fard
fards96629842fards
fare76354462fare
farl76338552farl
farm95934542farm
faros85532022faros
fart76860562fart
fas68262932fa_s
fash107232292fash
fast77052312fast
fat68178082fa_t
fate75444282fate
fats76252502fats
fatso85113492fatso
faun76226622faun
faux146519072faux
fava106820262fava
fave105532962fave
favor114712452favor
fawn105321952fawn
fax138143312fa_x
fay97454862fa_y
fays108535362fays
faze165630042faze
fed76548362fed_
feds85234322feds
feod815523002feod
fico95824602fico
fid76847702fid_
fidos95819062fidos
fids87034752fids
filo76034292filo
fino76034702fino
food86830572food
fordo97218652fordo
fro65530642f_ro
fud76335162fud_
fuds86528572fuds
gad57556662gad_
gadi66329732gadi
gadjo1436912gadjo
gads67843392gads
had77658772had_
hade85440202hade
hadj155818682hadj
halo76437322halo
hao67251122ha_o
jade125325452jade
jato115822682jato
judo125315312judo
kadi96224842kadi
kayo116417562kayo
kudo96115122kudo
lad48165712lad_
lade56345992lade
lads56549142lads
lady86527162lady
lido56028172lido
mad68958722mad_
made75440252made
mads76845382mads
mako105622362mako
mano66536812mano
mayo96524302mayo
nada58022912nada
ordo54622362ordo
pad68057332pad_
padi76331792padi
pads76742962pads
qadi145621112qadi
rad47662012rad_
radio64922492radio
radon64620502radon
rads56046612rads
rato45436972rato
redo56029372redo
sad47459212sad_
sade55544482sade
sadi55834652sadi
sago56332672sago
spado83713702spado
taco67031352taco
tad47959832tad_
tads57143952tads
tao38358952ta_o
tardo65321102tardo
taro46846912taro
udo49027312_udo
undo55620162undo
updo76712892updo
wad77053902wad_
wade85237072wade
wadi86228182wadi
wads87343152wads
wady115325002wady

Search took 3 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 Filter178691298720.580308087.9
2DLD Change Limit298721631.78016782.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911632.40674268.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.