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

324 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
relator7401636(None) 
delator83015021delator
realtor73611351realtor
relater73723141relater
relators83316121relators
ablator939842ablator
aerator7314842aerator
belabor1136292belabor
chelator1347912chelator
creator93714442cre_ator
cremator1269182cremator
deflator12328342deflator
delators92314822delators
dilator82712782dilator
elater64724202_elater
fellator1176712fellator
gelato73812952gelato_
gelatos83111512gelatos
legator83011132legator
levator10298962levator
negator83010672negator
predator11310052predator
reactor93011652reactor
realter73716312realter
realtors82811682realtors
rebater93517912rebater
rebato83714682rebato_
rebatos92913112rebatos
rector84019752re_ctor
redactor1147022redactor
regulator1046972regulator
relate64033632relat_e
related83327572related
relaters83218152relaters
relates73731432relates
relation82619772relation
relaxer143410222relaxer
revelator1286532revelator
rotator7310832rotator
senator7313072senator
abator84512713_abator
ablators1069873ablators
adulator948593adulator
aerators8315613aerators
alastor739653_alastor
aleatory1148813aleatory
aviator10229663aviator
beater84729393be_ater
beclamor1484303beclamor
beglamor1383193beglamor
belabors1236403belabors
belabour1243773belabour
belated103520013belated
belayer12339503belayer
belter84720963bel_ter
bettor83612223be_ttor
bleater94515303bleater
celadon1036913celadon
chelators1448163chelators
citator9310123citator
clamor1049453_clamor
collator10310373collator
correlator1245693correlator
creators102814413cre_ators
creditor1145903creditor
cremators1369813cremators
crematory1647203crematory
curator9312213curator
debater104114693debater
debtor938333de_btor
deflater123211603deflater
deflators13348153deflators
delate73827753delat_e
delated93722873delated
delates83526283delates
delation92318083delation
delayer113010533delayer
delegator1146243delegator
depilator1247653depilator
desolator1046673desolator
deviator1248313deviator
dewater112912423dewater
dilater83515653dilater
dilators93213193dilators
dilatory12279273dilatory
dilutor8256013dilutor
donator8310263donator
eater54639843_e_ater
editor738663_editor
elate55335883_elat_e
elated74725823_elated
elaters74420193_elaters
elates65032363_elates
elation73620453_elation
elector93313253_elector
elevator1146713elevator
emulator1048743emulator
enactor938033_enactor
enamor838753_enamor
epilator1049243epilator
equator1637483equator
erector93513813erector
exactor1636623_exactor
feater95224053fe_ater
fellators1247143fellators
fetor81214533fe__tor
flavor1236663_flavor
gator64416033__gator
gelate73421253gelat_e
gelated93615633gelated
gelates83219583gelates
gelati73814533gelat_i
gelatin83514733gelatin
gelation93014433gelation
gelatis83313513gelatis
genitor837273genitor
glamor958183_glamor
greater84416493gre_ater
gyrator1135713gyrator
heater94828303he_ater
hector113312653he_ctor
heritor10310563heritor
idolator946243idolator
inflator1158033inflator
isolator847533isolator
kelter103214383kel_ter
labor75117313__labor
later54843923__later
lector83514983le_ctor
legato72810953legato_
legators92811033legators
legatos82711183legatos
levators11249283levators
locator93110423locator
mediator1139043mediator
megaton10269853megaton
melter83520113mel_ter
melton8311553mel_ton
mentor8414363me_ntor
neater64424313ne_ater
negater83711963negater
negaton8299143negaton
negators92411173negators
nestor63713423ne_stor
oblatory1345793oblatory
operator10310093operator
orator6314533_orator
palpator1247123palpator
peculator1387863peculator
peloton938743peloton
pelter83321623pel_ter
plater84427693_plater
pleater93916333pleater
prealter1048863prealter
precatory1649113precatory
predators12310083predators
predatory1547703predatory
prefatory1746683prefatory
prelate9519693prelat_e
prelates10418573prelates
prelatic12311283prelatic
prelature1146263prelature
prelector1348093prelector
pretor8315753pre__tor
prolabor1284543prolabor
pronator10311783pronator
pulsator1085693pulsator
rabato83413263rabato_
rabatos93010903rabatos
radiator949203radiator
raptor83912823r_aptor
rater54943283r__ater
rato45436973r__ato_
ratos55528763r__atos
razor143012603r__azor
reactors103212283reactors
reader73628293re_ader
readorn8310483re_adorn
realer63528593re_aler
realgar834873realgar
reallot7312133reallot
realters83614043realters
realty92713693realt_y
reamer84325213re_amer
reaper84223143re_aper
rear45644553re_a__r
rearer64928913re_arer
reason62616333re_ason
reata54225393re_at_a
reatas64021013re_atas
reaver94524733re_aver
reavow1235723re_avow
rebar75420193reba__r
rebate84424113rebat_e
rebated103619703rebated
rebaters103413943rebaters
rebates95123183rebates
recanter101913153recanter
receptor1256693receptor
reciter94117263reciter
recolor978693recolor
recto74520803re_cto_
rectors93520523re_ctors
rectory123512733re_ctory
rectos85718783re_ctos
redactors1247533redactors
redate74124683redat_e
redated93120923redated
redates83423873redates
redtop937973re_dtop
reductor1156433reductor
reenactor1184353reenactor
reenter73217793reenter
reflate103516263reflat_e
reflated123514293reflated
reflates113115663reflates
reflation12412333reflation
reflector1445733reflector
refractor14156323refractor
refuter104312193refuter
regaler83814623regaler
regather1236733regather
regatta835963regatta
regulators1146503regulators
regulatory1445293regulatory
reheater113413033reheater
reinter73116843reinter
rejector17237723rejector
relabel938163relabel
relace83122153rela_ce
relaced103517213relaced
relaces93420883relaces
relaid75518443rela_id
reland75920433rela_nd
relands85214883relands
relapse947703relapse
relapser1035273relapser
relating92725443relating
relations92418333relations
relative11313143relative
relax124817803rela__x
relaxed153312533relaxed
relaxers15298263relaxers
relaxes143215323relaxes
relaxin14239183relaxin
relay84424673rela__y
relayed113212753relayed
relays94316753rela_ys
releaser839503releaser
relet54749823relet__
relets64025673relet_s
reletter81311023reletter
relier65826183rel_ier
relit55340683relit__
reloader937913reloader
relook104813743rel_ook
remaker133813173remaker
remaster10311473remaster
rematch1436193rematch
remate84428683remat_e
remated103522473remated
remates93827113remates
remittor10316553remittor
remoter94815973remoter
renature839323renature
renovator1244903renovator
renter64527413re_nter
repair84011463repa_ir
repaper11310023repaper
repatch1435843repatch
repeater102615443repeater
replacer12279743replacer
replaster1136583replaster
replate93420053replat_e
replated112817523replated
replates102919273replates
resat55139683resat__
resistor847673resistor
reslate73520593reslat_e
reslated93517523reslated
reslates83619503reslates
resonator946363resonator
rester63832433re_ster
restore75822983re_store
retailor8285223retailor
retaker113714313retaker
retore67630773re__tore
retorn610923433re__torn
retort66831153re__tort
retractor11218513retractor
retro55020953re__tro
reutter71010093reutter
revelators13116423revelators
revelatory16104673revelatory
revisor10388733revisor
rhetor938063r_hetor
rialto638603rialto_
rialtos736613rialtos
rogatory1246153rogatory
rolltop944043rolltop
rotators8310203rotators
rotatory1147213rotatory
rotor55519733r__otor
rubato8319683rubato_
rubatos9278653rubatos
seater64534163se_ater
sector83415933se_ctor
sedater83713633sedater
selector1048613selector
senators8312953senators
slater64429183_slater
stator64015483_stator
telamon936523telamon
testator847373testator
treater74219833tre_ater
urinator847843urinator
valuator1196723valuator
vector113212063ve_ctor
velar85817633vela__r
velate93720143velat_e
viator93211833_viator
violator1146283violator
weldor10317653wel_dor
welter93417383wel_ter

Search took 8 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 Limit1340273246.87619492.0
3Display Results3243240.1102945.5
 (SQL Overall)1786913247.39224173.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.