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

305 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
gentoo731131(None) 
gentoos838631gentoos
bento75922952bent_o
bentos86218302bentos
cento76625172cent_o
centos85920462centos
genitor837272genitor
genoa64315822gen_oa
genom83716842gen_om
genro64914032gen_ro
genros74211332genros
gent56954392gent__
gentes75324162gentes
gentil74115122gentil
gentle74014512gentle
gently103710912gently
gentry103410442gentry
gents65729612gent_s
lento57223392lent_o
lentos65317402lentos
mentor8414362mentor
agent65829643agent__
agented939423agented
agentry11165753agentry
agents74816293agent_s
bent67759913bent__
benthon1237693benthon
benthos1238373benthos
bents76033693bent_s
bentwood1444453bentwood
benzol1756993benzol
bestow1149463bestow
beton76022063be_ton
betook12439603be_took
bettor83612223bettor
canto74931013cant_o
canton85722993canton
cantor85621523cantor
cantos84826973cantos
cenote83715843cenote
censor84011283censor
cent67451013cent__
centai84814783centai
cental84420963cental
centas85020703centas
centavo1245103centavo
center84421413center
centimo11609543centimo
centra84113883centra
centre84316643centre
cents74730333cent_s
centu76119413cent_u
centum104012363centum
cestoi84511953cestoi
cestos84718093cestos
conto76027173cont_o
contos84923233contos
debtor938333debtor
denote74118043denote
dent57158413dent__
dental74319173dental
dented84120513dented
dentil74017883dentil
dentin73919573dentin
dentoid9310663dentoid
dents65031803dent_s
detox13310953de_tox
dextro1436123dextro
endow94510983_endow
enjoy1545963_enjoy
enol45823823_en_ol
enow77819873_en_ow
enrol51014283_enrol
enroot6615993_enroot
enter54726383_enter
entia5318203_entia
entoil6912493_entoil
entomb1037363_entomb
entozoa1644233_entozoa
entry82414263_entry
envoi878023_envoi
envoy1156723_envoy
estop74312103_estop
extol1247893_extol
fantod102010033fantod
fantom112110803fantom
festoon1037673festoon
fetor81214533fe_tor
ganof95420363gan_of
gantry103810113gantry
gator64416033g_ator
gazoo153112873g_azoo
gecko124511113ge_cko
geckos13457433geckos
gelato73812953gelato
gelatos83111513gelatos
gelt56448013gelt__
gelts65924613gelt_s
gemot84024233ge_mot
gemote94613023gemote
gemots93712153gemots
gen45950513gen___
gender83517933gender
gene56237223gen__e
genera71211713genera
genes65133093gen_es
genet66038683gen_et
genetic101211783genetic
genets75716663genets
genette838863genette
geneva1085853geneva
genial74917613genial
genic85119393gen_ic
genie66124923gen_ie
genies75324943genies
genii64514173gen_ii
genip84415203gen_ip
genips9469943genips
genital849793genital
genitors937423genitors
genius74512923genius
genoas74013623genoas
genome94312193genome
genoms94412483genoms
genre66016803gen_re
genres75515623genres
gens55740073gen__s
genteel836753genteel
gentian8310103gentian
gentile83515293gentile
gentled9389093gentled
gentler8378953gentler
gentles83714343gentles
genu55929073gen__u
genua64614153gen_ua
genus65319833gen_us
gesso649603ge_sso
gest56149133gest__
gestapo1044493gestapo
geste65920693gest_e
gestes75721393gestes
gestic9312773gestic
gests66028813gest_s
get47467463ge_t__
geta56627443ge_t_a
getas65421483ge_tas
gets55442483ge_t_s
getter74117613getter
getup83410263ge_tup
ghetto1036073ghetto
ghettos1134473ghettos
gingko12376033gingko
ginkgo12334943ginkgo
ginzo1539613gin_zo
gonion73612833gonion
gonof95218653gon_of
gonzo15310243gon_zo
goo47754773g___oo
grantor84010933grantor
grotto7349813grotto
guenon736403guen_on
gundog935793gundog
gunroom1045053gunroom
gusto65414643gust_o
hector113312653hector
hencoop1443813hencoop
hent76656383hent__
hented104218753hented
hents87330743hent_s
into45026153_int_o
intro54915853_intro
jeton124815403je_ton
jetton1338033jetton
junto125114563junt_o
juntos134110843juntos
kendo105113223ken_do
kendos114510663kendos
keno87926433ken__o
kenos95220623ken_os
kent86846963kent__
kente95821063kent_e
kentes105118643kentes
keto86223453ke_t_o
ketol95414003ke_tol
lector83514983lector
leno47331393len__o
lenos56024863len_os
lent46360533lent__
lenten6312883lenten
lentic83515743lentic
lentigo846063lentigo
lentil64315393lentil
lentoid8310683lentoid
lepton82510803lepton
lintol6369473lintol
melton8311553melton
meno66031363men__o
menta74424423ment_a
mental84521603mental
mentee84121293mentee
menthol1236723menthol
mention9314373mention
mentors9314993mentors
mentum104511713mentum
menudo945793menudo
metol75917813me_tol
metro74718803me_tro
nekton1036583nekton
nestor63713423nestor
netop7312343ne_top
newton936983newton
noo37154043__n_oo
obento837893obent_o
obentos936703obentos
onto46127663_ont_o
panto76129413pant_o
pantos85222743pantos
pengo84317593pen_go
pengos94612413pengos
pennon8310643pennon
pent66559073pent__
pentad9313763pentad
pentode1039893pentode
pentose9311593pentose
pentyl1138813pentyl
pesto75723723pest_o
pestos84719083pestos
petto76021043pe_tto
pinto75625753pint_o
pintos86021293pintos
ponton83217643ponton
pontoon93010703pontoon
punto75121323punt_o
puntos85915793puntos
recto74520803rect_o
rector84019743rector
rectos85718783rectos
redtop937973redtop
rent46661243rent__
rental63922023rental
rente54733783rent_e
rented74426593rented
renter64527413renter
rentes65431193rentes
rents55935183rent_s
renvoi945863renvoi
retook104313443re_took
retool63914483re_tool
retro55020953re_tro
santo56227283sant_o
santol64515243santol
santoor737433santoor
santos64421833santos
sector83415923sector
senator7313063senator
senhor93010803senhor
senior63214043senior
senor53822793sen_or
sensor63813833sensor
sent46963013sent__
sente56432873sent_e
senti56226703sent_i
sentimo9449623sentimo
sentry92912053sentry
seton55223543se_ton
sexto124415453sext_o
sexton133610793sexton
sextos134012163sextos
stentor739373stentor
tanto55724943tant_o
tattoo6310973tattoo
tendon7312033tendon
tenon53320513ten_on
tenor53620253ten_or
tensor63812673tensor
tent46159863tent__
tented74221003tented
tenter64623933tenter
tenth85421833tent_h
tenths94412663tenths
tentie62521183tentie
tents56434213tent_s
tenty86121603tent_y
tenuto648743tenuto
tenutos736623tenutos
teston6313303teston
testoon748373testoon
too38965423___too
unto45824283_unt_o
vector113212063vector
vendor10359803vendor
venom103914863ven_om
vent76049053vent__
vented104617923vented
venter94218723venter
vents86125933vent_s
veto76622993ve_t_o
wanton94413813wanton
went76051873went__
wonton93410963wonton
xenon122612453xen_on
yenta83917043yent_a
yentas94614213yentas
yente86220043yent_e
yentes95517603yentes

Search took 6 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 Limit1127163055.36021029.1
3Display Results3053050.0933279.6
 (SQL Overall)1786913055.57932029.2
 
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.