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

430 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
orator631453(None) 
orators7313821orators
oratory1039401oratory
abator84512712abator
aerator7314842aerator
crater85026642crater
craton84517192craton
creator93714442creator
curator9312212curator
donator8310262donator
frater94520592frater
gator64416032_gator
grantor84010932grantor
grater74625442grater
gyrator1135712gyrator
irater65218352irater
krater104014312krater
locator93110422locator
moratory1347822moratory
oater55433732o_ater
operator10310092operator
orate55133302orat_e
orated74221502orated
orates64328612orates
oration71617712oration
oratorio845632oratorio
praetor938972praetor
prater84825352prater
pretor8315752pretor
raptor83912822_raptor
rater54943282_rater
rato45436972_rato_
ratos55528762_ratos
razor143012602_razor
rotator7310832rotator
rotor55519732_rotor
sartor6313882sartor
stator64015482stator
tractor9311332tractor
traitor7310122traitor
viator93211832viator
abater85518123abater
abators94413083abators
ablator939843ablator
actor71116073_actor
adaptor1034943adaptor
aerators8315613aerators
alastor739653alastor
amatol838693amatol
amatory1238623amatory
arbor74818113ar_bor
ardor64617863ar_dor
armor75118053ar_mor
atom67824523__atom
atop66124753__atop
avatar937523avatar
aviator10229663aviator
barrator1048403barrator
barter85525373barter
baton75822423_baton
beater84729393beater
bettor83612223bettor
boater84622093boater
borate85026153borat_e
borated104116363borated
borates94823013borates
bracer104620583bracer
brat66055543brat__
brats75336013brat_s
bratty1159683bratty
braver114719043braver
bravo105214343bravo_
bravos114711393bravos
brawer114216333brawer
brayer115315313brayer
brazer174917533brazer
cantor85621523cantor
captor104914603captor
carter84932273carter
carton84522663carton
cartop104213563cartop
castor84418533castor
cater74840723_cater
chador1238673chador
chantor123710313chantor
citator9310123citator
clamor1049453clamor
coactor1139123coactor
coater84329573coater
cocreator1346963cocreator
cocurator1347573cocurator
cofactor1545753cofactor
collator10310373collator
copastor1246343copastor
coranto9311893coranto_
corantos10310103corantos
crafter124111333crafter
cratch134110793cratch
crate76537403crat_e
crated94827773crated
craters95021893craters
crates85736063crates
cratons94316033cratons
craver114618463craver
crayon114110003crayon
creators102814413creators
cremator1269183cremator
croton84415453croton
cruor7310453cr_uor
cuatro838433cuatro
curators10311723curators
darter75320363darter
dater65332313_dater
dato56129943_dato_
datos65222783_datos
debtor938333debtor
decorator1248573decorator
delator83015023delator
diatom939453diatom
dilator82712783dilator
doctor938993doctor
donators9310403donators
dorado838813dorado_
dorados938203dorados
drafter11449423drafter
dragon838843dragon
draper94315693draper
drat56247833drat__
drats66628373drat_s
drawer104711363drawer
eater54639843_eater
editor738663editor
elater64724203elater
enactor938033enactor
enamor838753enamor
equator1637483equator
eraser64216333eraser
erector93513813erector
error53712233er_ror
evocator1346573evocator
exactor1636623exactor
factor11911453factor
favor114712453_favor
feater95224053feater
fetor81214533_fetor
flavor1236663flavor
foetor939563foetor
forager114412563forager
forayer13368953forayer
foretop12117893foretop
fractur12135563fractur
fraktur14153033fraktur
framer114817443framer
frat75648543frat__
fraters103517213fraters
frats86829673frat_s
garter74420513garter
gater64533653_gater
gators74115833_gators
glamor958183glamor
grader84919693grader
grafter114211153grafter
granter84117133granter
grantors93810353grantors
grat55651283grat__
grate64932883grat_e
grated84523923grated
graters85419743graters
grates75429893grates
gratin74520583gratin
gratis74819243gratis
graver105018593graver
grayer106014543grayer
grazer164815763grazer
greater84416493greater
gyrators1245993gyrators
gyratory1544163gyratory
harbor11410723harbor
hater85034753_hater
heater94828303heater
hector113312653hector
heritor10310563heritor
horror988723hor_ror
hortatory1544743hortatory
hydrator1545763hydrator
idolator946243idolator
irate55627983irat_e
isolator847533isolator
jato115822683_jato_
jatos125116823_jatos
juratory1845183juratory
korat94934433korat__
korats105416063korat_s
kraters114212343kraters
kronor10417233kronor
labor75117313_labor
later54843923_later
lector83514983lector
legator83011133legator
levator10298963levator
lictor83610853lictor
locater93113603locater
locators102910433locators
major145212923_major
manor78023933_manor
martyr1135693martyr
mater74438863_mater
mayor106616623_mayor
mentor8414363mentor
migrator1147873migrator
mirador1046503mirador
moderator12106543moderator
monitor9310723monitor
moratoria1146133moratoria
mortar83812043mor_tar
motor75317293_motor
narrator847563narrator
neater64424313neater
negator83010673negator
nestor63713423nestor
nitrator849553nitrator
nonactor1047773nonactor
oar37057953o_a__r
oat39888263o_at__
oaten55222403o_aten
oaters65029793o_aters
oath76132153o_at_h
oaths86117313o_aths
oats46554213o_at_s
oblatory1345793oblatory
obturator1144703obturator
obviator1344743obviator
odor55718093o__dor
ofter84116873o_fter
onager739663onager
onto46127663o_nto_
operators11410753operators
ora37250833ora___
orach105219233ora_ch
orache114013593orache
oracle84313293oracle
orad56031693ora__d
oral47638123ora__l
orally93113593orally
orals55826483ora_ls
orang65119943ora_ng
orange74016323orange
orangs74116033orangs
orangy105111233orangy
orating83520323orating
orations81515803orations
oratories9410643oratories
oratorios944923oratorios
oratrix1444533oratrix
orbier839993orbier
orbiter937853orbiter
order65019363or_der
ordo54622353or_do_
ordos65216203or_dos
organon845913organon
orison6411663orison
orlon5415003or_lon
orlop7410903or_lop
ormer75218373or_mer
ornate6315143ornat_e
ort39465233or_t__
ortho8312293or_tho
orts46538333or_t_s
orzo134516783or_zo_
orzos143311253or_zos
osar46820953osa__r
ottar54313993o_ttar
otter54423973o_tter
otto45220643o_tto_
ottos54714323o_ttos
ouster64223733ouster
outer55633303o_uter
ovate84214393ovat_e
ovation101510023ovation
oviraptor1441943oviraptor
oxter123414093o_xter
oyster94111703oyster
parador103311413parador
parlor8312673parlor
parton84720993parton
pastor84817483pastor
pater74740723_pater
payor105413843_payor
perorator1149743perorator
plater84427693plater
porter84224413por_ter
potato8513433potato_
potatory1348413potatory
praetors1039833praetors
prao66229023pra_o_
praos74923563pra_os
prat65952043prat__
prate75135983prat_e
prated94924923prated
praters94921653praters
prates84633163prates
prats76333393prat_s
prayer114815293prayer
predator11310053predator
pretors9316813pretors
prior74316173pr_ior
proctor11310433proctor
pronator10311783pronator
proton84318893proton
prutot8311823prutot
racer75233023_racer
racon75422143_racon
radar61316723_radar
radon64620503_radon
rafter94517583_rafter
ragtop936683_ragtop
raker94529793_raker
rancor8810373_rancor
ranter63826823_ranter
raper74932753_raper
raptors94213353_raptors
rarer54731703_rarer
raser55633413_raser
raster64731443_raster
rat37892743_rat__
ratal55025113_ratal
ratan53722663_ratan
ratch104221363_ratch
rate45458763_rat_e
rated65441383_rated
ratel54224883_ratel
raters63936583_raters
rates55352013_rates
rath76037663_rat_h
rathe85821923_rathe
rather94319743_rather
ratio55227583_ratio
ration64226013_ration
ratios64922673_ratios
ratoon64417373_ratoon
rats46260373_rat_s
ratter64326313_ratter
ratton64116123_ratton
ratty84819593_ratty
raver85631493_raver
rawer84623733_rawer
rayon83815703_rayon
razer144824273_razer
razors154711663_razors
reactor93011653reactor
realtor73611353realtor
rector84019753rector
relator74016363relator
retore67630773_retore
retorn610923433_retorn
retort66831153_retort
retro55020953_retro
rhetor938063rhetor
rigor62714053_rigor
roamer84715163roamer
roar46328573roa__r
roarer63914333roarer
roaster74116663roaster
rogatory1246153rogatory
rooter64926033rooter
roster64329083roster
rotators8310203rotators
rotatory1147213rotatory
roto45935053_roto_
rotors64917953_rotors
rotos56027883_rotos
rotter64325463rotter
router65025843router
rumor71011323_rumor
sapor75119253_sapor
sartors7314973sartors
satori6415843_satori
satyr848483_satyr
savor85417943_savor
seater64534163seater
sector83415933sector
senator7313073senator
skater105015493skater
skatol1035723skatol
slater64429183slater
sordor7310223sor_dor
sorter64425093sor_ter
stater64427563stater
stators73915583stators
suitor63311053suitor
tabor75518393_tabor
tartar63214753tartar
tarter64023563tarter
tatar56122063_tatar
tater54138613_tater
titrator858543titrator
tolerator956753tolerator
tomato8313453tomato_
tor39261683___tor
toreador945003toreador
torpor839193tor_por
tracer84820233tracer
tractors10312563tractors
trader75218763trader
traditor945943traditor
traitors8310793traitors
treater74219833treater
tremor84210403tremor
triter65120593triter
triton63914893triton
trustor7238413trustor
tutor5712493_tutor
urate55432163urat_e
urates65027763urates
uratic83016353uratic
ureter6313203ureter
urinator847843urinator
valor83614893_valor
vapor104013093_vapor
varactor1345683varactor
vector113212063vector
viators102712023viators
vibrator13227343vibrator
victor113210673victor
violator1146283violator
water84733313_water
wrath115715873wrat_h
wraths123810083wraths
wrathy15377853wrathy
writer94416513writer

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164305.79619447.2
3Display Results4304300.1562756.4
 (SQL Overall)1786914306.34228175.8
 
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.