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

165 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
fajitas173425(None) 
fajita1635921fajita_
agitas7310592_agitas
ajivas1655132_ajivas
caritas93316952caritas
casitas93312042casitas
facias113415802faci_as
faiths124610272fa_iths
farinas103215232farinas
raitas64417672ra_itas
adits66523713_adit_s
afrits9311903afrit_s
agita6315423_agita_
aits46355533_a_it_s
ajiva1586803_ajiva_
ajugas1435263_ajugas
alias55834603_ali_as
aliyas93911803_aliyas
amanitas1048533amanitas
amias75831473_ami_as
amigas95912173_amigas
amritas939093amritas
animas84418723_animas
antas55432033_a_ntas
aortas65417783_aortas
arias55438023_ari_as
aristas7413523_aristas
axites134913833_axites
baits76630583ba_it_s
baizas173810823ba_izas
balatas9311833balatas
baristas1039723baristas
barites94322333barites
barytas12378283barytas
bonitas939453bonitas
camisas113411923camisas
capias10318353capi_as
capita102913773capita_
capital112311523capital
capitals12209443capitals
carinas93622403carinas
casita82913703casita_
dacites101114593dacites
davits104012363davit_s
ditas65923673__ditas
facets116316653facet_s
facia103218463faci_a_
faciae112913413faci_ae
facial113615633faci_al
facials123310743facials
facies113921593faci_es
facings134511263facings
facts107021893fa_ct_s
fadings12469303fadings
faenas94412763fa_enas
fagins10513863fagi_ns
fagots1039963fagot_s
fails85631483fa_i_ls
faints94818783fa_ints
fairs85825443fa_i_rs
faith115620853fa_it_h
fakirs13468083faki_rs
famines123216263famines
fanegas1145713fanegas
fangas105017193fa_ngas
fanions103713073fanions
fanjets1734803fanjet_s
fantasm1236593fa_ntasm
fantast10311703fa_ntast
fantasy1336153fa_ntasy
faqirs18456033faqi_rs
farina94618233farina_
farinhas14325363farinhas
farts88336843fa_rt_s
fascias1258413fascias
fascitis1346013fascitis
fasts86429683fa_st_s
fatal84819373fa__tal
fates85139233fa__tes
fats76252503fa__t_s
fatties103018203fatties
fatwas1249053fa_twas
faults94513553fault_s
faunas94013633fa_unas
favas115618593fa__vas
favelas1337023favelas
favisms1535443favisms
feijoas1742323feijoas
ferias95020393feri_as
fetas85624403f__etas
fiats85324483f__iats
fiestas1038433fiestas
finites10315923finites
fits76043463f__it_s
flautas1036153flautas
flites95122443f_lites
flits85625223f_lit_s
flotas94013003f_lotas
fomites123613203fomites
frites94922483f_rites
friths124313583f_riths
frits86129103f_rit_s
fritts94613193f_ritts
fruits94512493fruit_s
fujis15379243fuji__s
gaits65726013ga_it_s
granitas92610223granitas
gravitas12316013gravitas
habitan1236903habitan
habitans1346623habitans
habitat12411053habitat
habitats1346733habitats
habits113014653habit_s
habitus12338173habitus
hadiths1436023hadiths
hajis156716283haji__s
halites103221193halites
halitus10339963halitus
hejiras1744233hejiras
jarinas143712183jarinas
jotas125717443__jotas
katas95922093ka__tas
lamias85020613lami_as
laminas93615873laminas
lanital7310913lanital
lanitals837723lanitals
lariats7615053lariats
latinas74416463latinas
litas54923773__litas
mafias113913573mafi_as
manias84029033mani_as
manilas93915873manilas
manitos9314053manitos
manitus9310923manitus
mantas85725363ma_ntas
marinas93519383marinas
marital92314183marital
nairas6312783na_iras
paisas84317493pa_isas
pajamas18278153pajamas
partitas10310253partitas
pastas85422873pa_stas
patinas96318523patinas
pitas77427673__pitas
raias54631123ra_i_as
raita54623073ra_ita_
rajas127317723raj__as
ratites74920683ratites
saigas74114293sa_igas
salinas73116093salinas
salivas10309603salivas
samites93118713samites
sapotas939613sapotas
tafias93111963tafi_as
taigas73712563ta_igas
taxites1449673taxites
vaginas11298813vaginas
valutas1036533valutas
varias95019903vari_as
veritas103012753veritas
waits88333523wa_it_s
wapitis1236473wapitis
yautias1046333yautias
zamias174212923zami_as
zaribas1836043zaribas

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.423422437.4
2DLD Change Limit1340271655.92022639.7
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.40627894.3
 
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.