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

228 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
fajita163592(None) 
fajitas1734251fajitas
agita6315422_agita
ajiva1586802_ajiva
capita102913772capita
casita82913702casita
facia103218462faci_a
faith115620852fa_ith
farina94618232farina
raita54623072ra_ita
aceta74017353_aceta
acta69524803_a_cta
adit56443653_adit_
adits66523713_adits
adyta936853_adyta
afrit8323173afrit_
afrits9311903afrits
agitas7310593_agitas
ait38093903_a_it_
aits46355533_a_its
ajivas1655133_ajivas
ajuga1335883_ajuga
alit46155693_alit_
aliya83713483_aliya
amanita9310453amanita
amia66836903_ami_a
amiga85514813_amiga
amity10416093_amity
amrita8411133amrita
anima74620073_anima
anta46839583_a_nta
aorta55922573_aorta
aria46245423_ari_a
arista6415293_arista
axite125218253_axite
bait66556003ba_it_
baith108023133ba_ith
baits76630583ba_its
baiza164813223ba_iza
balata8614673balata
barista9310813barista
barite84224813barite
baryta114310293baryta
bonita8312943bonita
camisa103114323camisa
capital112311523capital
carina84325323carina
caritas93316953caritas
casitas93312043casitas
cavity14310013cavity
dacite91115883dacite
data56026653da__ta
davit93424593davit_
davits104012363davits
dita56032523__dita
facet106038523facet_
facete115014833facete
facets116316653facets
faciae112913413faciae
facial113615633facial
facias113415803facias
facies113921593facies
facile112514883facile
facing125321573facing
fact97142543fa_ct_
facts107021893fa_cts
facula112912233facula
fading114821113fading
faena85014203fa_ena
fagin9216573fagi_n
fagins10513863fagins
fagot9323403fagot_
fagots1039963fagots
fail74840243fa_i_l
fails85631483fa_ils
fain75840563fa_i_n
faint85837063fa_int
faints94818783faints
fair76332523fa_i_r
fairs85825443fa_irs
fairy115318283fa_iry
faiths124610273fa_iths
faking145520983faking
fakir125111493faki_r
fakirs13468083fakirs
falsity1335903falsity
family143311703family
famine114318193famine
faming124922973faming
famish14311843famish
fanega1055783fanega
fanga96119623fa_nga
fanion94514323fanion
fanjet16311393fanjet_
fanjets1734803fanjets
faqir17548643faqi_r
faqirs18456033faqirs
farinas103215233farinas
faring105231283faring
farinha13357063farinha
fart76860563fa_rt_
farts88336843fa_rts
fascia1148703fascia
fast77052313fa_st_
fasts86429683fa_sts
fat68178083fa__t_
fatal84819373fa__tal
fate75444283fa__te
fating105328673fating
fats76252503fa__ts
fatty115117413fa_tty
fatuity1336043fatuity
fatwa1168063fa_twa
fault85428313fault_
faults94513553faults
faulty12429363faulty
fauna84816513fa_una
fava106820263fa__va
favela1237033favela
favism1437913favism
faxing175117053faxing
faying134521073faying
fazing194418643fazing
feijoa1642223feijoa
feria85922713feri_a
ferity122813343ferity
feta76528903f__eta
fiat76646643f__iat
fiesta938123fiesta
fila74729133f__ila
finite9316823finite
finito9310303finito
fit66365453f__it_
fits76043463f__its
fixit154819303fixit_
fixity19427803fixity
flauta937823flauta
flit76539273f_lit_
flite85424963f_lite
flits85625223f_lits
flota85315643f_lota
folia83618933foli_a
fomite113314073fomite
frit77044473f_rit_
frith115922033f_rith
frits86129103f_rits
fritt86129413f_ritt
fritz176020773f_ritz
fruit85122223fruit_
fruits94512493fruits
fruity12429693fruity
frusta937453frusta
fuji144112003fuji__
fujis15379243fuji_s
gait56150193ga_it_
gaits65726013ga_its
granita82111303granita
habit103027023habit_
habitan1236903habitan
habitat12411053habitat
habits113014653habits
hadith13312063hadith
haika125313793ha_ika
haji148520193haji__
hajis156716283haji_s
halite93624233halite
haniwa1236743haniwa
hejira1644803hejira
jarina134014063jarina
jota116423623__jota
kata85626023ka__ta
labia75219013labi_a
laith85722103la_ith
laity85318903la_ity
lamia75324323lami_a
lamina84920443lamina
lanital7310913lanital
lariat6629043lariat
latina65621143latina
laxity1637273laxity
mafia104418033mafi_a
makuta1236393makuta
mania75634153mani_a
manila84518303manila
manito8518693manito
manitu8315823manitu
manta75629913ma_nta
maria75032883mari_a
marina84623413marina
marital92314183marital
maxima17568633maxima
naira5314743na_ira
paisa76021073pa_isa
pajama17317653pajama
parity114719873parity
partita9310863partita
pasta76624533pa_sta
patina86022193patina
pita65436433__pita
raia46638383ra_i_a
raitas64417673ra_itas
raja117918683raj__a
rarity93615493rarity
ratite65022423ratite
saiga64717933sa_iga
saith85826553sa_ith
salina64221123salina
saliva93110743saliva
samite83020603samite
sancta839833sancta
sanity9316203sanity
sapota8310213sapota
tacit76333673tacit_
tafia84215493tafi_a
taiga64115663ta_iga
tapeta8310693tapeta
taxite13511303taxite
vagina102710933vagina
valuta938743valuta
vanity12311933vanity
varia85824203vari_a
vita75828523__vita
wait75553693wa_it_
waits88333523wa_its
wapiti1138363wapiti
yautia937253yautia
zamia165115213zami_a
zariba1736983zariba

Search took 5 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162284.64024292.2
3Display Results2282280.0763000.0
 (SQL Overall)1786912284.84236904.4
 
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.