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

280 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
relators8331613(None) 
delators92314831delators
realtors82811681realtors
relaters83218151relaters
relator74016371relator_
ablators1069882ablators
aerators8315612aerators
belabors1236402belabors
chelators1448162chelators
creators102814412cre_ators
cremators1369822cremators
deflators13348152deflators
delator83015032delator_
dilators93213202dilators
elaters74420192_elaters
fellators1247142fellators
gelatos83111522gelato_s
legators92811032legators
levators11249282levators
negators92411172negators
predators12310082predators
reactors103212292reactors
realters83614042realters
realtor73611352realtor_
rebaters103413942rebaters
rebatos92913112rebato_s
rectors93520522re_ctors
redactors1247542redactors
regulators1146502regulators
relater73723142relater_
relates73731432relat_es
relations92418332relations
relaxers15298262relaxers
revelators13116422revelators
rotators8310202rotators
senators8312952senators
abators94413093_abators
ablator939853ablator_
adulators1048063adulators
aerator7314843aerator_
alastors8311223_alastors
aleatory1148823aleatory
aviators11169903aviators
beaters94925043be_aters
beclamors1574223beclamors
beglamors1473373beglamors
belabor1136293belabor_
belabours1343543belabours
belayers13298143belayers
belters93819413bel_ters
bettors93312473be_ttors
bleaters103412323bleaters
celadons1137003celadons
chelator1347913chelator_
citators10310253citators
clamors11710093_clamors
collators11410343collators
correlators1345593correlators
creator93714443cre_ator_
creditors1245873creditors
cremator1269193cremator_
crematory1647213crematory
curators10311723curators
debaters113511923debaters
debtors1038533de_btors
deflaters13298703deflaters
deflator12328343deflator_
delates83526283delat_es
delations102616593delations
delayers12268663delayers
delegators1245633delegators
depilators1347333depilators
desolators1146283desolators
deviators1358533deviators
dewaters122910723dewaters
dilaters92513063dilaters
dilator82712793dilator_
dilatory12279283dilatory
dilutors9306653dilutors
donators9310403donators
eaters65535953_e_aters
editors839423_editors
elater64724203_elater_
elates65032363_elat_es
elations83719123_elations
electors103013853_electors
elevators1246303elevators
emulators1148183emulators
enactors1038463_enactors
enamors939123_enamors
epilators1149433epilators
equators1737473equators
erectors103514263erectors
exactors1737023_exactors
fellator1176713fellator_
fetors91014473fe__tors
flavors1337293_flavors
gators74115843__gators
gelates83219593gelat_es
gelatins93414093gelatins
gelations102513093gelations
gelatis83313513gelat_is
gelato73812963gelato__
genitors937423genitors
glamors1068123_glamors
gyrators1246003gyrators
heaters104225223he_aters
hectors123513263he_ctors
heritors11310903heritors
idolators1046283idolators
inflators1257713inflators
isolators947513isolators
kelters113813753kel_ters
labors84016413__labors
lectors93415773le_ctors
legator83011133legator_
legatos82711183legato_s
levator10298963levator_
levatores12225743levatores
locators102910433locators
mediators1248923mediators
megatons11279703megatons
melanous1048603melanous
melters93918313mel_ters
meltons9410923mel_tons
mentors9314993me_ntors
negaters9349783negaters
negatons9299273negatons
negator83010673negator_
nestors73614973ne_stors
oblatory1345803oblatory
operators11410753operators
orators7313823_orators
palpators1346803palpators
peculators1486983peculators
pelotons1038913pelotons
pelters93720313pel_ters
platers93924093_platers
pleaters103613793pleaters
prealters1147773prealters
precatory1649113precatory
predator11310053predator_
predatory1547703predatory
prefatory1746683prefatory
prelates10418573prelat_es
prelature1146273prelature
prelatures1245733prelatures
prelectors1447873prelectors
pretors9316813pre__tors
pronators11411303pronators
pulsators1175373pulsators
rabatos93010903rabato_s
radiators1049323radiators
raptors94213353r_aptors
raters63936583r__aters
ratos55528763r__ato_s
razors154711663r__azors
reactor93011663reactor_
readers83823773re_aders
readorn8310483re_adorn
readorns938283re_adorns
realgars934533realgars
reallots837993reallots
realter73716313realter_
realties8514853realties
reamers94221083re_amers
reapers93520453re_apers
rearers74323563re_arers
rears54739653re_a__rs
reasons72514943re_asons
reatas64021013re_at_as
reavers108320743re_avers
reavows1335273re_avows
rebars84019833reba__rs
rebater93517913rebater_
rebates95123183rebat_es
rebato83714683rebato__
recanters112310483recanters
receptors1356923receptors
reciters102613113reciters
recolors1078813recolors
rector84019753re_ctor_
rectory123512733re_ctory
rectos85718783re_cto_s
redactor1147033redactor_
redates83423873redat_es
redtops1037373re_dtops
reductors1246523reductors
reenactors1294383reenactors
reenters82915303reenters
reflates113115663reflat_es
reflations13311233reflations
reflectors1545503reflectors
refractors15156273refractors
refuters11449613refuters
regalers94311133regalers
regathers1336353regathers
regattas944473regattas
regulator1046973regulator_
regulatory1445293regulatory
reheaters122010273reheaters
reinters82614773reinters
rejectors18247613rejectors
relabels1045343relabels
relaces93420883rela_ces
relands85214883rela_nds
relapsers1164123relapsers
relapses1038033relapses
relate64033633relat__e
related83327573relat_ed
relating92725443relating
relation82619773relation
relative11313143relative
relatives1239963relatives
relaxer143410223relaxer_
relaxes143215323rela_xes
relaxins15248683relaxins
relays94316753rela__ys
releasers937323releasers
relets64025673relet__s
reletters9138783reletters
reliers75519213rel_iers
reloaders1036423reloaders
relooks114010723rel_ooks
remakers143811303remakers
remasters11310583remasters
remates93827113remat_es
remittors11256283remittors
renature839333renature
renatures939453renatures
renovators1344843renovators
renters74224813re_nters
repairs9319973repa_irs
repapers1258833repapers
repeaters112811993repeaters
replacers13266833replacers
replasters1245533replasters
replates102919273replat_es
resistors947993resistors
reslates83619503reslat_es
resonators1045813resonators
resters74130403re_sters
restore75822983re_store
restores85222993re_stores
retailors9285363retailors
retakers123511133retakers
retore67630773re__tore
retorn610923433re__torn
retort66831153re__tort
retorts76016513re__torts
retractors12158583retractors
retros63820193re__tros
reutters8138573reutters
revelator1286533revelator_
revelatory16104673revelatory
revisors11379063revisors
rhetors1038513r_hetors
rialtos736613rialto_s
rogatory1246153rogatory
rotator7310833rotator_
rotatores946483rotatores
rotatory1147213rotatory
rotors64917953r__otors
rubatos9278653rubato_s
seaters74028943se_aters
sectors93116453se_ctors
selectors1148973selectors
senator7313073senator_
slaters73123733_slaters
stators73915583_stators
testators947333testators
treaters83615843tre_aters
urinators947633urinators
valuators1286473valuators
vectors123212593ve_ctors
velars93913723vela__rs
viators102712023_viators
violators1246583violators
weldors11238003wel_dors
welters103516063wel_ters

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.453394461.4
2DLD Change Limit1461622808.26617682.3
3Display Results2802800.1402000.0
 (SQL Overall)1786912808.85920170.6
 
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.