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

427 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
gelants8261144(None) 
gelant72821671gelant_
gellants9308281gellants
alants67722022_alants
bezants1877342bezants
decants103514442decants
elands74914772_elands
elans55527752_elan_s
elints65816422_elints
eluants737582_eluants
gallants93310372gallants
geladas936312geladas
gelate73421262gela_te
gelates83219592gelates
gelati73814532gela_ti
gelatis83313512gelatis
gelato73812962gela_to
gelatos83111522gelatos
gellant83214052gellant_
gelts65924612gel__ts
gents65729612ge__nts
gerents82612922gerents
giants74713502g_iants
glands85314402g_lands
glans65125832g_lan_s
gleans75014742glean_s
glints75714212g_lints
grants73722472g_rants
levants1037722levants
pedants10310112pedants
plants84921802_plants
recants93217092recants
relands85214882relands
relents74018502relents
replants102811242replants
sealants82610742sealants
secants93413892secants
slants64819082_slants
tenants7311012tenants
ablauts936083ablauts
agents74816293age__nts
alands75418373_alands
alans55636173_alan_s
alant55742293_alant_
ants47243473___ants
aslant6317753aslant_
atlantes838553atlantes
beanos85516513be_anos
beans75734693be_an_s
beasts84519723be_asts
beats76042243be_a_ts
beauts86015283be_auts
belauds1036643belauds
belays114313853bela_ys
belongs10408223belongs
belons84119413belon_s
belts75931163bel__ts
bents76033693be__nts
bepaints1235113bepaints
bezant17814543bezant_
bezzants1843643bezzants
blanks124112893_blanks
blasts85116773_blasts
blats75132503_bla_ts
bleats85518613blea_ts
blunts84512893_blunts
brants85723053_brants
byzants2153223byzants
callants104112143callants
cants77036943__cants
celts75325783cel__ts
cements112714223cements
cents74730333ce__nts
cetanes9315133cetanes
chants115020393_chants
clangs95113613_clangs
clanks124615183_clanks
clans75031013_clan_s
clasts84817293_clasts
cleans85817053clean_s
cleats84919313clea_ts
coolants1039943coolants
deans66131393de_an_s
decanes103118913decanes
decant93524223decant_
dedans85915073dedan_s
defangs1235363defangs
defats105114553defa_ts
delaines9312963delaines
delate73827753dela_te
delates83526283delates
delays104014053dela_ys
delfts10439673del_fts
delicts104012253delicts
delists84414173delists
delts65731793del__ts
demands114311413demands
demasts1089223demasts
dements103016623dements
dents65031803de__nts
depaints1136643depaints
departs104310683departs
deplanes11311213deplanes
derats74625063dera_ts
desalts839573desalts
desands94810163desands
descants112910143descants
detents83615153detents
deviants1236733deviants
dewans105215143dewan_s
dopants1038433dopants
easts57530323_e_asts
eats47054873_e_a_ts
eclats8313033ecla_ts
eggplants1342753eggplants
elains64919853_elains
elan46734243_elan__
eland65820393_elan_d
elate55335883_ela_te
elates65032363_elates
elects83315003_elects
elint55436473_elint_
eluant6315093_eluant_
eluents738703_eluents
enacts84012973_enacts
epacts105010393_epacts
errants7410643errants
events94814073_events
exacts15359613_exacts
exalts13328313_exalts
explants1737023explants
feasts95116093fe_asts
feats86432753fe_a_ts
feints94813873fe_ints
felines104718073felines
felons93615763felon_s
felts85324543fel__ts
fenlands1245183fenlands
flanes94522423_flanes
flanks133913403_flanks
flans85327973_flan_s
flats86429743_fla_ts
flaunts1056133_flaunts
flints95617453_flints
gaits65726013g__aits
galagos938153galagos
galahs105512683gala_hs
galanga936023galanga
galangas1046173galangas
galas65731643gala__s
galavants1343943galavants
galaxes1538883galaxes
galenas83310343galenas
galiots82311323galiots
galivants1344203galivants
gallant83517113gallant_
gallets83517403gallets
gallnuts943923gallnuts
galoots82410793galoots
gamelans11115853gamelan_s
gangs76222583g__angs
garlands1038323garlands
gasts66628633g__asts
gats56753443g__a_ts
gears64628693ge_a_rs
geests75912163ge_ests
gelable101710733gelable
gelada837623gela_da
gelated93615643gelated
gelatin83514733gelatin
gelatines102910543gelatines
gelatins93414093gelatins
gelcaps1235203gelcaps
gelders93812573gelders
geldings11316163geldings
gelds75118343gel__ds
gelees74116263gel_ees
gels56836103gel___s
gelt56448013gel__t_
gemots93712153ge_mots
genes65133093ge__nes
genets75716663ge_nets
gens55740073ge__n_s
gent56954393ge__nt_
gentes75324163ge__ntes
genus65319833ge__nus
gerahs1039413gera_hs
gerent73223103gerent_
germans1079473german_s
gerunds935183gerunds
gestalts955493gestalts
gests66028813ge__sts
getas65421483geta__s
gets55442483ge___ts
ghats95818613g_ha_ts
ghauts10447783g_hauts
giant65430593g_iant_
gillnets934733gillnets
gilts64924263gil__ts
gitanos837173gitanos
glaces94218033g_laces
glacis94012133g_lacis
glades84820343g_lades
glads75620613g_la_ds
glairs75211333g_lairs
glams85822933g_la_ms
glance94312313g_lance
glances104113143g_lances
gland75217713g_lan_d
glandes95413833g_landes
glares75518873g_lares
glass65518133g_la_ss
glazes165315643g_lazes
gleams94812253glea_ms
glean65818203glean__
gleaned9349423gleaned
gleaner8379773gleaner
gleaners9348073gleaners
gleets75315053g_leets
glens66519853g_len_s
glint66830183g_lint_
glinty106910693g_linty
gloats74515423g_loats
glosts74513813g_losts
glouts74414713g_louts
gluts66120133g_l_uts
gnats65217713g_na_ts
goats65527303g_oa_ts
gobangs11385833gobangs
gobans94412043goban_s
gowans105512293gowan_s
grafts105013253g_rafts
grands84218243g_rands
grans64832543g_ran_s
grant64840023g_rant_
greats76318393grea_ts
grievants1342353grievants
groans74815063groan_s
groats74816653groa_ts
grunts75511853g_runts
guanos73811993g_uanos
guans64419443g_uan_s
gulags837543gula_gs
gullets84013713gullets
hants86335403__hants
hearts96218943he_arts
heats85838403he_a_ts
heliasts1136103heliasts
helmets12309073helmets
helots95217703hel_ots
hents87330743he__nts
hexanes17319463hexanes
implants1237883implants
incants92012803incants
infants102210773infants
inlands838783inlands
islands837323islands
jeans126022113je_an_s
jurants14379213jurants
kelts95222633kel__ts
lands65426903__lands
lanes54946793__lanes
lasts57731263__lasts
lats45962703__la_ts
leans55536253le_an_s
leant56737783le_ant_
leasts64616413le_asts
lemans85316393leman_s
levant9314493levant_
libelants1145303libelants
lints57137193__lints
llanos6108333_llanos
lunts55826903__lunts
means75831233me_an_s
meant76537213me_ant_
meats75034053me_a_ts
mediants11299493mediants
melange1038363melange
melanges1138613melanges
melanic11310403melanic
melanics1237733melanics
melanin9310893melanin
melanins10310383melanins
melanism1239363melanism
melanist10313053melanist
melanists1148623melanists
melanite10512033melanite
melanites11410733melanites
melanous1048603melanous
melenas999203melenas
melons84117713melon_s
melts74930103mel__ts
mutants938583mutants
neats55931903ne_a_ts
oblasts947303oblasts
octants9128733octants
operants1039483operants
pageants1136693page_ants
pants76536923__pants
peans75437643pe_an_s
peanuts936993pe_anuts
peasants1038263peasants
peats76140193pe_a_ts
pecans101515833pecan_s
pedant9319493pedant_
pekans121710553pekan_s
pelages10714613pelages
pellets94014783pellets
pelmets11309693pelmets
peltasts1035703peltasts
pelts76128813pel__ts
penangs10268373penangs
pendants1139093pendants
pennants1037063pennants
pieplants1355433pieplants
plaints94012053_plaints
plaits83816473_plaits
planes85028083_planes
planets93914083_planets
planks124116753_planks
plans75731273_plan_s
plant75437113_plant_
plats75531373_pla_ts
pleats85218593plea_ts
quants153614143_quants
rants55935343__rants
reacts83616603re_acts
rebaits9312573rebaits
recanes93222263recanes
recant83228683recant_
recasts93413533recasts
redacts10510943redacts
redans75421023redan_s
regents83416543regents
regrants9310013regrants
rehangs1137563rehangs
relaces93420883relaces
reland75920433relan_d
relate64033633rela_te
relates73731433relates
relaxants1643243relaxants
relaxes143215323relaxes
relays94316753rela_ys
relends84013253relends
relent64431853relent_
relets64025673rel_ets
reliant7319243reliant_
relicts94414593relicts
relines75331323relines
relinks114510223relinks
relists73817053relists
reloans7313133reloan_s
relucts9369673relucts
remands104914883remands
remans84823003reman_s
remints95117293remints
remnants1036843remnants
rents55935183re__nts
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replans92814943replan_s
replant93318533replant_
rerents73319423rerents
resents74221223resents
retints74717013retints
savants1038653savants
scants85219723_scants
sealant73118303sealant_
seats54844343se_a_ts
seawants11337973seawants
secant84023293secant_
sedans74816093sedan_s
sejant133114483sejant_
selahs9313213sela_hs
selects91912143selects
servants1138003servants
sewans95215903sewan_s
sextants15287383sextants
silanes72517163silanes
silents73514493silents
sklents11348163sklents
slangs75615343_slangs
slant55238703_slant_
slanty95114843_slanty
slats55436903_sla_ts
solands84412343solands
solanos74412853solanos
solans64122493solan_s
sonants7511233sonants
splats84817303spla_ts
splents93912133splents
splints94511743splints
talents7312013talents
teats55636813te_a_ts
telnets738373telnets
tenant6322473tenant_
tents56434213te__nts
tetanus737933tetanus
tolanes74216313tolanes
tolans64319273tolan_s
truants738163truants
tyrants1037453tyrants
uhlans937573uhlan_s
ulans54921303_ulan_s
umlauts943193umlauts
uplands1036943uplands
valiants1137793valiants
vegans103910853vegan_s
velars93913723vela_rs
velate93720143vela_te
veldts10417753vel_dts
velvets13326693velvets
vents86125933ve__nts
versants1137783versants
volant9316323volant_
volante1038513volante
wants87932213__wants
weans85326743we_an_s
welts85225193wel__ts
wetlands1244763wetlands
xylans1635883xylan_s
yeans86624883ye_an_s
yeasts96413053ye_asts
yulans958673yulan_s
zealots1636763zealots
zenanas16286233zenanas

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.406440125.6
2DLD Change Limit1340274275.82623005.0
3Display Results4274270.1562737.2
 (SQL Overall)1786914276.38827972.9
 
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.