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

195 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
geladas93631(None) 
gelada837621gelada_
gelants82611442gelants
gelates83219592gelates
gelatis83313512gelatis
gelatos83111522gelatos
gelds75118342gel_d_s
glades84820342g_lades
glads75620612g_lad_s
agendas936933age_ndas
aggadas1055003aggadas
armadas1038173armadas
balatas9311833balatas
beads85429503be_ad_s
beglads11127263beglad_s
beladies11310423beladies
belady12489933belad_y
belauds1036643belauds
belays114313853bela_ys
beldam11410113bel_dam
beldams1237053beldams
belgas9311713bel_gas
belugas1035903belugas
bemadam1445773bemadam
bemadams1543383bemadams
blades95221253_blades
celadon1036913celadon
celadons1137003celadons
cicadas1235993cicadas
clades94920463_clades
clads85722733_clad_s
dadas75819863__dadas
deads75726913de_ad_s
decadal1137243decadal
decades113615513decades
delates83526283delates
delays104014053dela_ys
deleads9379703delead_s
deltas74414823del_tas
deludes91810643deludes
egads74610923_egad_s
elains64919853_elains
elands74914773_elands
elans55527753_ela_ns
elates65032363_elates
elds56324863_el_d_s
elides74420693_elides
elodeas836963_elodeas
eludes75417683_eludes
evades1039023_evades
felids103111623felid_s
fellas95116963fel_las
gadis74825293g__adis
gads67843393g__ad_s
galabias1137733galabias
galagos938153galagos
galahs105512683gala_hs
galangas1046173galangas
galas65731643g__alas
galateas937153galateas
galaxes1538883galaxes
galeas74618513gal_eas
galenas83310353galenas
gamas85431363g__amas
gears64628693ge_a_rs
geds66730823ge__d_s
geishas1135083geishas
gelable101710733gelable
gelant72821673gela_nt
gelate73421263gela_te
gelated93615643gelated
gelati73814533gela_ti
gelatin83514733gelatin
gelatins93414093gelatins
gelato73812963gela_to
gelcap1136213gel_cap
gelcaps1235203gelcaps
geld65828433gel_d__
gelded94512113gel_ded
gelder84613713gel_der
gelders93812573gelders
gelees74116263gel_ees
gelid74916983gelid__
gelidly1234753gelidly
gellants9308283gellants
gels56836103gel___s
gelts65924613gel__ts
genevas1185253genevas
genoas74013623ge_noas
geodes8412153ge_odes
geoidal936713geoidal
geoids8369843geoid_s
gerahs1039413gera_hs
gerardias1144403gerardias
getas65421483ge__tas
getaway1444013getaway
getaways1543343getaways
gilds75417533gil_d_s
glaces94218033g_laces
glacis94012133g_lacis
glad65624013g_lad__
glade75121963g_lad_e
gladly11497933g_ladly
glady105413943g_lad_y
glairs75211333g_lairs
glams85822933g_la_ms
glandes95413833g_landes
glands85314403g_lands
glans65125833g_la_ns
glares75518873g_lares
glass65518133g_la_ss
glazes165315643g_lazes
gleams94812253glea_ms
gleans75014743glea_ns
gledes84915133g_ledes
gleds75417893g_led_s
gleeds84711623gleed_s
glias64618493g_l_ias
glides84518863g_lides
goads77022853g_oad_s
golds75421313gol_d_s
gonadal956523gonadal
gonads84511733gonad_s
grades84926313g_rades
grads75625753g_rad_s
gradus84411223g_radus
gramas94317203g_ramas
grenades1038433grenades
guavas1037163g_uavas
gulags837543gula_gs
halalas104214083halalas
hamadas1339673hamadas
heads95127113he_ad_s
hexades18378703hexades
hexads17468203hexad_s
jehads1735833jehad_s
jellabas1744073jellabas
jemadar1743373jemadar
jemadars1842543jemadars
lades65141273__lades
lads56549143__lad_s
lamas75532793__lamas
lavas85422223__lavas
leads66028493le_ad_s
llamas888973_llamas
meads85425323me_ad_s
medakas1435763medakas
melds84822383mel_d_s
melenas999203melenas
melodias1148703melodias
menads95514383menad_s
miladis1049823miladis
nadas66320813__nadas
palapas11311493palapas
panadas103312213panadas
pelages10714613pelages
pelotas9410723pelotas
pesades10310903pesades
playas114612283_playas
plazas17409913_plazas
pleads94613953plead_s
posadas1037193posadas
ramadas1039303ramadas
readds84111643re_adds
reads64835273re_ad_s
reatas64021013re_atas
reclads1049993reclad_s
relaces93420883relaces
relands85214883relands
relates73731433relates
relaxes143215323relaxes
relays94316753rela_ys
reloads8911313reload_s
remudas1035833remudas
resedas839123resedas
salads75316963salad_s
seladang1043403seladang
seladangs1142383seladangs
selahs9313213sela_hs
selvas93812913sel_vas
teledus835093teledus
telegas837443telegas
tuladis835703tuladis
ulamas8910453_ulamas
unlades82612833unlades
velars93913723vela_rs
velds95615583vel_d_s
veldts10417753vel_dts
verandas1246233verandas
wealds10459103weald_s
welds94719163wel_d_s
welladay1572933welladay
welladays1672153welladays
zenaidas18513663zenaidas
zenanas16286233zenanas

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.436409841.7
2DLD Change Limit1340271956.78319759.3
3Display Results1951950.0762565.8
 (SQL Overall)1786911957.29524495.0
 
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.