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

235 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
senators831295(None) 
senator7313071senator_
aerators8315612aerators
delators92314832delators
donators9310402donators
enactors1038462_enactors
enamors939122_enamors
genitors937422genitors
legators92811032legators
levators11249282levators
mentors9314992men_tors
negators92411172negators
relators83316132relators
seaters74028942se_aters
sectors93116452se_ctors
senates73322612senat_es
senhors103512132sen_hors
seniors73413622sen_iors
senors63620792sen__ors
sensors73514642sen_sors
stators73915582s_tators
stentors839752sten_tors
abators94413093_abators
ablators1069883ablators
aerator7314843aerator_
alienators1045783alienators
assentors955663assen_tors
aviators11169913aviators
beaters94925043be_aters
belabors1236403belabors
bentos86218303ben_to_s
bettors93312473be_ttors
cantors94620753can_tors
censors93611843cen_sors
centaurs1035733centaurs
centers94420603cen_ters
centos85920463cen_to_s
chantors133710263chantors
chelators1448173chelators
citators10310253citators
coenamors1344703coenamors
creators102814413creators
cremators1369823cremators
curators10311723curators
debaters113511923debaters
debtors1038533de_btors
deflators13348153deflators
delator83015033delator_
denars74621433dena__rs
denature938073denature
denatures1038133denatures
detonators1145853detonators
deviators1358543deviators
dewaters122910723dewaters
dilators93213203dilators
donator8310263donator_
eaters65535953_e_aters
editors839423_editors
elaters74420193_elaters
elevators1246303elevators
emanators1147033emanators
emendators1344203emendators
enactor938043_enactor_
enactory1346153_enactory
enamor838753_enamor_
enamours1044663_enamours
enates64026433_enat_es
enations83316903_enations
enters64425643_en_ters
equators1737473equators
exactors1737023_exactors
fellators1247143fellators
fetors91014473fe__tors
functors1335743functors
gators74115843__gators
gelatos83111523gelato_s
generators1147533generators
genitor837273genitor_
gentoos838633gen_toos
grantors93810363grantors
gyrators1246003gyrators
heaters104225223he_aters
hectors123513263he_ctors
heritors11310903heritors
ignitors9135513ignitors
isolators947513isolators
janitors1536853janitors
lectors93415773le_ctors
legator83011133legator_
legatos82711183legato_s
lentos65317403len_to_s
levator10298963levator_
levatores12225743levatores
locators102910433locators
mandators1247873mandators
mediators1248923mediators
megatons11279703megatons
menacers12279313menacers
menazons1945733menazons
mentor8414363men_tor_
minatory1338553minatory
monitors10310823monitors
negaters9349783negaters
negatons9299273negatons
negator83010673negator_
nestors73614973ne_stors
nonactors1147883nonactors
operators11410753operators
orators7313823_orators
penates93321603penat_es
pensters103012123pensters
predators12310083predators
pronators11411303pronators
reactors103212293reactors
realtors82811683realtors
rebaters103413943rebaters
rebatos92913123rebato_s
rectors93520523re_ctors
redactors1247543redactors
reenactors1294383reenactors
relaters83218153relaters
relator74016373relator_
renature839333renature
renatures939453renatures
renovators1344843renovators
renters74224823ren_ters
resonators1045813resonators
rotators8310203rotators
sabatons1037843sabatons
sacatons1038973sacatons
sanatoria947173sanatoria
santirs7312963san_tirs
santols73513323san_tols
santoors837633santoors
santos64421833san_to_s
santours837183san_tours
santurs7310763san_turs
sapors84118813s__apors
sartors7314973s_artors
satori6415843s__atori
satoris7317253s__atoris
satyrs937963s__atyrs
savors95616103s__avors
seadogs958643se_adogs
seahorse1145593se_ahorse
sealers74323553se_alers
seamers94719433se_amers
seaport9315603se_aport
seaports1038463se_aports
sears54744913se_a__rs
seasons72614233se_asons
seater64534163se_ater_
seats54844343se_at__s
seatwork1546783se_atwork
seatworks1646303se_atworks
seawaters1235713seawaters
secateurs1142723secateurs
secretors1145843secretors
sector83415933se_ctor_
sedater83713633sedater_
sedates83418043sedat_es
sedations10311253sedations
seisors73212843se_isors
seizors16329013se_izors
selectors1148973selectors
senarius8310103senarius
senary93716073sena__ry
senate63725173senat__e
senatorial1047323senatorial
senatorian1046693senatorian
senatorship1654493senatorship
senders83022353sen_ders
senhor93010813sen_hor_
senhora10348673sen_hora
senhoras11278283sen_horas
senhores112810993sen_hores
senior63214053sen_ior_
senor53822803sen__or_
senora63216163sen__ora
senoras72714953sen__oras
senores73218113sen__ores
sensates8511143sensat_es
sensations1059853sensations
sensor63813843sen_sor_
sensory10329093sen_sory
sensuous845903sensuous
sentry92912053sen_t_ry
sepalous1047523sepalous
separators1246503separators
servitors1245213servitors
setons64620173se__tons
setous64917373se__tous
setters73822063se_tters
settlors8255013settlors
sewars94018633sewa__rs
sextons143710413se_xtons
sextos134012163se_xto_s
signatory1344623signatory
sinters74024083sin_ters
skaters113512963s_katers
skatols1135533s_katols
slaters73123733s_laters
snarers74216663s_narers
snathes104816493s_nathes
snaths95112913s_nat_hs
sneakers12308643sneakers
sonars64818973sona__rs
sonatas7510293sonat_as
sonicators1277063sonicators
spectators1444533spectators
squalors1744583squalors
staters73922343s_taters
stator64015483s_tator_
stentor739383sten_tor_
stertors8310933stertors
stratous8410703stratous
subatoms1245883subatoms
sudatory1245843sudatory
suitors73012493s_uitors
supinators1245643supinators
sweaters113811063sweaters
synagogs1343273synagogs
synanons1144633synanons
tenors63217753ten__ors
tensors72712373ten_sors
tenters73921113ten_ters
tenutos736623tenuto_s
testators947333testators
urinators947633urinators
vectors123212593ve_ctors
venations12311723venations
vendors113510223ven_dors
venerators1347063venerators
venters103717733ven_ters
viators102712023_viators

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622357.79618748.3
3Display Results2352350.1102136.4
 (SQL Overall)1786912358.32621461.8
 
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.