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

175 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
oratory103940(None) 
moratory1347821moratory
orator6314531orator_
orators7313821orators
amatory1238642amatory
gyratory1544172gyratory
hortatory1544742hortatory
juratory1845182juratory
oblatory1345802oblatory
oratorio845642oratorio
potatory1348412potatory
rogatory1246152rogatory
rotatory1147212rotatory
abator84512723abator_
abators94413093abators
aerator7314843aerator_
aerators8315613aerators
aleatory1148823aleatory
anatomy1246233anatomy
armory114211473ar_mory
artery9911453ar_tery
atomy107415193__atomy
atony87218853__atony
atopy106813393__atopy
bratty1159683brat_ty
bravery15428133bravery
calory11312843_calory
citatory1347213citatory
crater85026643crater_
craters95021893craters
craton84517193crato_n
cratons94316033cratons
creator93714443creator_
creators102814413creators
crematory1647213crematory
curator9312213curator_
curators10311723curators
datary10310243_datary
dilatory12279283dilatory
donator8310263donator_
donators9310403donators
dormitory1543253dormitory
drapery13387943drapery
eatery95316353_eatery
enactory1346153enactory
factory15108353factory
feretory1447513feretory
flavory1644743flavory
frater94520593frater_
fraters103517213fraters
fumatory1644923fumatory
gator64416043_gator_
gators74115843_gators
gramary1355913gramary
granary1157793granary
grantor84010943grantor_
grantors93810363grantors
grapery13457953grapery
grater74625443grater_
graters85419743graters
gratify1436113gratify
gyrator1135723gyrator_
gyrators1246003gyrators
herstory1446693herstory
history1339423history
horary12310383hora__ry
irately1047683irately
irater65218353irater_
krater104014313krater_
kraters114212343kraters
laboratory1543683laboratory
lavatory1445703lavatory
libratory14255803libratory
locator93110423locator_
locators102910433locators
locutory1344273locutory
martyry1533373martyry
migratory1545343migratory
minatory1338553minatory
monitory1347853monitory
moratoria1146143moratoria
mortary12369043mor_tary
natatory1146613natatory
nonstory1148103nonstory
nugatory1245273nugatory
oater55433733o_ater_
oaters65029793o_aters
olfactory1743093olfactory
operator10310093operator_
operators11410753operators
orality101111683orality
orally93113593ora_lly
orangery12305543orangery
orangey11388833orangey
orangy105111233ora_ngy
orate55133303orat__e
orated74221503orat_ed
orates64328613orat_es
orating83520323orating
oration71617713oration
orations81515803orations
oratories9410653oratories
oratorios944923oratorios
oratrix1444543oratrix
ornately1144813ornately
ornery938463or_nery
orology11319463orology
orrery936783or_rery
ostomy1137833o_stomy
outcry1137993o_utcry
ovary1149113ova__ry
ovately1334433ovately
overstory1546143overstory
ovulatory1544833ovulatory
phratry1543743phrat_ry
praetor938973praetor_
praetors1039833praetors
prater84825353prater_
praters94921653praters
precatory1649113precatory
predatory1547703predatory
prefatory1746683prefatory
pretor8315753pretor_
pretors9316813pretors
priory114110263pr_iory
probatory1647113probatory
purgatory1544413purgatory
raptor83912823_raptor_
raptors94213353_raptors
ratany93411873_ratany
rater54943283_rater_
raters63936583_raters
ratify122610043_ratify
rato45436973_rato__
ratoon64417373_ratoon
ratos55528763_rato_s
rattly94111543_rattly
ratty84819593_rat_ty
razor143012603_razor_
razors154711663_razors
rectory123512733rectory
retore67630773_retore
retorn610923433_retorn
retort66831153_retort
retry84718083_ret_ry
robotry1244173robotry
rotary92411303_rotary
rotator7310833rotator_
rotators8310203rotators
rotor55519733_rotor_
rotors64917953_rotors
sartor6313883sartor_
sartors7314973sartors
satori6415843_satori
savory124310563_savory
stator64015483stator_
stators73915583stators
story86723033__story
suasory1046043suasory
sudatory1245843sudatory
tomatoey1344103tomatoey
tory75840543___tory
tracery12399793tracery
tractor9311343tractor_
tractors10312573tractors
traitor7310123traitor_
traitors8310793traitors
vapory14398763_vapory
viator93211833viator_
viators102712023viators
vibratory17235563vibratory
victory15326983victory
vomitory1644413vomitory
watery123914493_watery
wrathy15377853wrat_hy

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271757.50017870.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.98622375.5
 
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.