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

248 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
gentoos83863(None) 
gentoo7311311gentoo_
benthos1238372benthos
bentos86218302bent_os
centos85920462cent_os
genitors937422genitors
genoas74013622gen_oas
genoms94412482gen_oms
genros74211332gen_ros
gentes75324162gent_es
gentles83714342gentles
gents65729612gent__s
lentos65317402lent_os
mentors9314992mentors
aeneous739893aeneous
agents74816293agent__s
argentous1045603argentous
benthon1237693benthon
benthons1337973benthons
bento75922953bent_o_
bents76033693bent__s
bentwood1444453bentwood
bentwoods1543993bentwoods
benzols1836673benzols
bestows1248863bestows
betons84919553be_tons
betook12439603be_took
bettors93312473bettors
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
cenotes92814543cenotes
censors93611843censors
centals94317053centals
centas85020703cent_as
centavos1344783centavos
centers94420603centers
centimos12507323centimos
cento76625173cent_o_
centones10313663centones
centres93817123centres
cents74730333cent__s
centums11398783centums
cestos84718093cest_os
contos84923233cont_os
debtors1038533debtors
denotes83817003denotes
dentals83915393dentals
dentils84115583dentils
dentins83419223dentins
dentoid9310663dentoid
dents65031803dent__s
endows104610423_endows
enjoys1644603_enjoys
enols54718403_en_ols
enows85115493_en_ows
enrols61213383_enrols
enroot6615993_enroot
enroots738713_enroots
enters64425643_enters
entoil6912493_entoil
entoils7810733_entoils
entomb1037363_entomb
entombs1135613_entombs
entozoa1644233_entozoa
envois988703_envois
envoys1255143_envoys
estops84011223_estops
ethos85514193_e_thos
extols1337683_extols
fantods11177623fantods
fantoms12189153fantoms
festoon1037673festoon
festoons1136443festoons
fetors91014473fe_tors
ganofs104010293gan_ofs
gators74115833g_ators
gazoos163010223g_azoos
geckoes14325793geckoes
geckos13457433ge_ckos
gelatos83111513gelatos
gelts65924613gelt__s
gemotes103712143gemotes
gemots93712153ge_mots
genders93616783genders
generous939773generous
genes65133093gen__es
geneses82613523geneses
genesis82510823genesis
genetics11128613genetics
genets75716663gen_ets
genettes938303genettes
genevas1185253genevas
genies75324943gen_ies
genips9469943gen_ips
genitals937243genitals
genitor837273genitor
genius74512923gen_ius
genoa64315823gen__oa
genoise839423gen_oise
genom83716843gen__om
genome94312193gen_ome
genomes103611703genomes
genres75515623gen_res
genro64914033gen_ro_
gens55740073gen___s
gent56954393gent___
genteel836753genteel
gentian8310103gentian
gentians937563gentians
gentil74115123gent_il
gentile83515293gentile
gentiles93713523gentiles
gentle74014513gent_le
gentled9389093gentled
gentler8378953gentler
gentlest93410573gentlest
gently103710913gent_ly
gentries91315263gentries
gentry103410443gent_ry
genus65319833gen__us
genuses83510883genuses
gessoes838293gessoes
gestapos1153913gestapos
gestes75721393gest_es
gests66028813gest__s
getas65421483ge_t_as
gets55442483ge_t__s
getters84216103getters
getups9346853ge_tups
ghettoes1243493ghettoes
ghettos1134473ghettos
gingkos13405343gingkos
ginkgos13314183ginkgos
ginzoes1735433ginzoes
gonofs10459863gon_ofs
goos57644913g___oos
grantors93810353grantors
grottos8337333grottos
guenons836563guen_ons
gundogs1034603gundogs
gunroom1045053gunroom
gunrooms1144323gunrooms
gustoes879873gustoes
hectors123513263hectors
hencoop1443813hencoop
hencoops1543213hencoops
hents87330743hent__s
intros64215773_intros
jetons134512613je_tons
jettons1437273jettons
juntos134110843junt_os
kendos114510663ken_dos
kenos95220623ken__os
kentes105118653kent_es
ketols104210763ke_tols
lectors93415763lectors
lenos56024863len__os
lentils73912973lentils
lento57223393lent_o_
lentoid8310683lentoid
lentoids947443lentoids
leptons91910433leptons
lintols7339553lintols
meltons9410923meltons
mentees93214503mentees
menthol1236723menthol
menthols1347033menthols
mention9314373mention
mentions10312893mentions
mentor8414363ment_or
menudos1034643menudos
metols84115773me_tols
metros84217803me_tros
nektons1136393nektons
nestors73614973nestors
netops839213ne_tops
newtons1036813newtons
obentos936703obent_os
pantos85222743pant_os
pengos94612413pen_gos
pennons939713pennons
pentads1039523pentads
pentode1039893pentode
pentodes11310363pentodes
pentose9311593pentose
pentoses10312893pentoses
pentyls1236523pentyls
pestos84719083pest_os
pintoes95117713pintoes
pintos86021293pint_os
pontons93315553pontons
pontoon93010703pontoon
pontoons10279313pontoons
puntos85915793punt_os
rectors93520523rectors
rectos85718783rect_os
redtops1037373redtops
rentals74017473rentals
renters74224813renters
rentes65431193rent_es
rents55935183rent__s
renvois1036503renvois
retook104313443re_took
retool63914483re_tool
retools73411023re_tools
retros63820193re_tros
santols73513323santols
santoor737433santoor
santoors837633santoors
santos64421833sant_os
sectors93116453sectors
senators8312953senators
senhors103512133senhors
seniors73413623seniors
senors63620793sen_ors
sensors73514643sensors
sentimos10407423sentimos
setons64620173se_tons
setous64917373se_tous
sextons143710413sextons
sextos134012163sext_os
stentors839743stentors
tattoos738643tattoos
tendons8311473tendons
tenons62916603ten_ons
tenors63217753ten_ors
tensors72712373tensors
tenters73921103tenters
tenths94412663tent_hs
tents56434213tent__s
tenuous738483tenuous
tenutos736623tenutos
testons7313563testons
testoon748373testoon
testoons837323testoons
vectors123212593vectors
vendors113510223vendors
venoms114211213ven_oms
venous93713193ven_ous
venters103717733venters
vents86125933vent__s
vetoes92914083ve_toes
wantons103713013wantons
wontons103310533wontons
xenons132710483xen_ons
yentas94614213yent_as
yentes95517603yent_es

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 Limit1340272485.97022450.1
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.46927622.7
 
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.