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_
orators7313801orators
amatory1238612amatory
gyratory1544162gyratory
hortatory1544742hortatory
juratory1845182juratory
oblatory1345792oblatory
oratorio845632oratorio
potatory1348412potatory
rogatory1246142rogatory
rotatory1147202rotatory
abator84512713abator_
abators94413073abators
aerator7314843aerator_
aerators8315613aerators
aleatory1148813aleatory
anatomy1246233anatomy
armory114211473ar_mory
artery9911453ar_tery
atomy107415193__atomy
atony87218853__atony
atopy106813393__atopy
bratty1159683brat_ty
bravery15428133bravery
calory11312843_calory
citatory1347203citatory
crater85026633crater_
craters95021883craters
craton84517193crato_n
cratons94316033cratons
creator93714433creator_
creators102814383creators
crematory1647193crematory
curator9312213curator_
curators10311703curators
datary10310243_datary
dilatory12279273dilatory
donator8310263donator_
donators9310383donators
dormitory1543253dormitory
drapery13387943drapery
eatery95316353_eatery
enactory1346143enactory
factory15108343factory
feretory1447503feretory
flavory1644743flavory
frater94520593frater_
fraters103517203fraters
fumatory1644923fumatory
gator64416033_gator_
gators74115823_gators
gramary1355903gramary
granary1157793granary
grantor84010933grantor_
grantors93810353grantors
grapery13457953grapery
grater74625433grater_
graters85419733graters
gratify1436113gratify
gyrator1135713gyrator_
gyrators1245993gyrators
herstory1446693herstory
history1339423history
horary12310383hora__ry
irately1047683irately
irater65218343irater_
krater104014313krater_
kraters114212333kraters
laboratory1543683laboratory
lavatory1445693lavatory
libratory14255803libratory
locator93110423locator_
locators102910413locators
locutory1344273locutory
martyry1533373martyry
migratory1545323migratory
minatory1338553minatory
monitory1347853monitory
moratoria1146133moratoria
mortary12369043mor_tary
natatory1146603natatory
nonstory1148063nonstory
nugatory1245273nugatory
oater55433733o_ater_
oaters65029783o_aters
olfactory1743083olfactory
operator10310093operator_
operators11410753operators
orality101111683orality
orally93113593ora_lly
orangery12305543orangery
orangey11388833orangey
orangy105111233ora_ngy
orate55133303orat__e
orated74221503orat_ed
orates64328613orat_es
orating83520323orating
oration71617713oration
orations81515793orations
oratories9410633oratories
oratorios944923oratorios
oratrix1444523oratrix
ornately1144813ornately
ornery938463or_nery
orology11319463orology
orrery936783or_rery
ostomy1137823o_stomy
outcry1137993o_utcry
ovary1149113ova__ry
ovately1334433ovately
overstory1546143overstory
ovulatory1544833ovulatory
phratry1543743phrat_ry
praetor938973praetor_
praetors1039833praetors
prater84825353prater_
praters94921643praters
precatory1649113precatory
predatory1547703predatory
prefatory1746683prefatory
pretor8315743pretor_
pretors9316803pretors
priory114110263pr_iory
probatory1647103probatory
purgatory1544413purgatory
raptor83912823_raptor_
raptors94213353_raptors
ratany93411873_ratany
rater54943283_rater_
raters63936573_raters
ratify122610043_ratify
rato45436973_rato__
ratoon64417373_ratoon
ratos55528763_rato_s
rattly94111543_rattly
ratty84819593_rat_ty
razor143012603_razor_
razors154711653_razors
rectory123512723rectory
retore67630763_retore
retorn610923423_retorn
retort66831143_retort
retry84718083_ret_ry
robotry1244163robotry
rotary92411303_rotary
rotator7310823rotator_
rotators8310183rotators
rotor55519733_rotor_
rotors64917933_rotors
sartor6313873sartor_
sartors7314953sartors
satori6415833_satori
savory124310563_savory
stator64015473stator_
stators73915553stators
story86723033__story
suasory1046043suasory
sudatory1245843sudatory
tomatoey1344093tomatoey
tory75840543___tory
tracery12399793tracery
tractor9311333tractor_
tractors10312553tractors
traitor7310123traitor_
traitors8310773traitors
vapory14398763_vapory
viator93211833viator_
viators102712013viators
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.1561145455.1
2DLD Change Limit1340271758.75015317.4
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.96919923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.