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

189 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
yautias104633(None) 
yautia937251yautia_
dauties83315762dauties
yantras10259002yantras
abulias93210693abulias
actins86321103_actins
agitas7310593_agitas
agrias74315393_agrias
alias55834603_a_lias
amias75831473_a_mias
amusias938583amusias
antas55432033_ant_as
antiar6317173_antiar
antiars7314623_antiars
antics84621453_antics
antis55033313_anti_s
anurias7312253anurias
arias55438023_a_rias
atlas55821583_a_tlas
atmas75721013_a_tmas
attics84413283_attics
audial7312993_audial
audios72312283_audios
audits72814113_audits
aunties73920073_aunties
auras55932553_au_ras
auris55331533_auri_s
autism83815333_autism
autisms94311553_autisms
autist64324943_autist
autists73814853_autists
autos56523323_aut_os
auxins13129813_auxins
banties94324763banties
batiks1239373ba_tiks
battiks1337143battiks
bawties124214313bawties
beauties10229523beauties
cantinas102713773cantinas
capias10318353ca_pias
cardias10715113cardias
caritas93316953caritas
casitas93312043casitas
cassias93514343cassias
catties94023053catties
caulis85320083cauli_s
caustics1237483caustics
caution93013523caution
cautions103313183cautions
cautious103110233cautious
cuties84927363_cuties
cutins83919983_cutins
cutis77723763_cuti_s
cutlas8313103_cutlas
dahlias1135723dahlias
daturas838773daturas
dautie72914703dauti_e
dauting93814763dauting
dauts67822243daut__s
dawties113312703dawties
deutzias1842633deutzias
dhutis1035943dhuti_s
dulias71212743_dulias
duties74921903_duties
dysurias1244463dysurias
facias113415803fa_cias
fajitas1734253fajitas
fascias1258413fascias
fatties103018203fatties
fatwas1249053fa_twas
faucial1257323faucial
faunas94013633fau_nas
flautas1036153flaut_as
gambias125010733gambias
gaudies9311973gaudies
kalmias1347973kalmias
katas95922093ka_t_as
kauries113613193kauries
kauris103611533kauri_s
laities7320343laities
lamias85020613la_mias
latinas74416463la_tinas
latrias71913213latrias
lattins74115483lattins
lauras63414333lau_ras
maffias15327283maffias
mafias113913573ma_fias
maftirs1236043maftirs
malthas1237913malthas
manias84029033ma_nias
mantas85725363mant_as
mantids103113623mantids
mantis83926033manti_s
mantras93815863mantras
mantuas93410993mantuas
martial92415413martial
martian93514683martian
martians103111613martians
martins93322063martins
mastics112614783mastics
matins84527783ma_tins
mattins93316143mattins
matzas1749703ma_tzas
mauts75927193maut__s
myalgias14123893myalgias
nasties73520493nasties
nauseas735993nauseas
nautical1057703nautical
nautili746113nautili
nautilus844073nautilus
nubias8310093_nubias
nutrias739813_nutrias
opuntias10103233opuntias
outgas7313203_outgas
panties94230933panties
partial92616263partial
partials101911953partials
parties93230863parties
partitas10310253partitas
pastas85422873past_as
pasties94529813pasties
pastils94416173pastils
pastinas103712153pastinas
pastis84924323pasti_s
patinas96318523pa_tinas
patins87528783pa_tins
patios85221783pa_tios
patties93425143patties
paulins9312613paulins
pyaemias1545063pyaemias
pyurias1236713pyurias
raffias13237713raffias
raias54631123ra__ias
raitas64417673rait_as
ramtils938413ramtils
raphias123511083raphias
ratios64922673ra_tios
rutins63818393_rutins
salties73725773salties
salvias10279933salvias
santims9312603santims
santirs7312963santirs
satins64930483sa_tins
satis55633683sa_ti_s
saunas63915433sau_nas
saurian739913saurian
saurians837763saurians
sauries72821623sauries
sautes63924913saut_es
sautoirs834923sautoirs
scotias939753scotias
sutras64818593_sutras
suttas63813793_suttas
tactics1149323tactics
taenias7311283taenias
taffias13377413taffias
tafias93111963ta_fias
tantras73112093tantras
tarsias74013373tarsias
tatties74120343tatties
tautens7317843tautens
tauting83316383tauting
tautogs875413tautogs
tauts56125513taut__s
thulias1035743thulias
utas45924953__ut_as
valutas1036533valut_as
varias95019903va_rias
yabbies14279643yabbies
yagis95416573ya_gi_s
yamulkas1741793yamulkas
yantra9449623yantra_
yatters103914623yatters
yauds95013223yau__ds
yaupers12337663yaupers
yauping13357243yauping
yaupons12345683yaupons
yaups105910743yau__ps
yentas94614213yent_as
yetis85418393y_eti_s
youths124510043yout_hs
yttrias1044523yttrias
yucas106013913y_u_cas
yuccas13426553y_uccas
yugas95012063y_u_gas
yutzes18408413y_utzes
zamias174212923za_mias
zaptiah2144293zaptiah
zaptiahs2242063zaptiahs

Search took 8 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 Limit1340271897.09318895.7
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.32924381.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.