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

238 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
rectory12351272(None) 
rector84019741rector_
rectors93520511rectors
directory1545862directory
erector93513802erector_
erectors103514252erectors
factory15108342factory
hector113312652hector_
hectors123513262hectors
lector83514982lector_
lectors93415762lectors
nectary1246222nectary
precatory1649112precatory
reactor93011652reactor_
reactors103212282reactors
recarry1245062recarry
recopy1339042rec_opy
record96117422rec_ord
recork126315482rec_ork
rectify1536452rectify
recto74520802recto__
rectos85718782recto_s
refectory1746022refectory
restore75822972restore
retore67630762re_tore
retorn610923422re_torn
retort66831142re_tort
retry84718082re_t_ry
sectary1238272sectary
sector83415922sector_
sectors93116432sectors
vector113212062vector_
vectors123212592vectors
victory15326982victory
actor71116073_actor_
actorly1246413_actorly
actors81016753_actors
aleatory1148813aleatory
amatory1238613amatory
betony114211583be_tony
bettor83612223bettor_
bettors93312473bettors
century1237193century
cory96941513__c_ory
creator93714433creator_
creators102814383creators
crematory1647193crematory
debtor938333debtor_
debtors1038533debtors
decor84717573dec_or_
decors94017773dec_ors
decoy115716313dec_o_y
decretory1544673decretory
decry115514353dec__ry
decury1277963dec_ury
destroy1138153destroy
director1147773director_
directors1248133directors
doctor938993doctor_
doctorly1443113doctorly
doctors1039983doctors
eatery95316353_eatery
echoey14397853_echoey
ejector16378603ejector_
ejectors17328663ejectors
elector93313253elector_
electors103013843electors
enactory1346143enactory
entry82414263_ent_ry
erecter93113393erecter_
erecters102611613erecters
erectly1257473erect_ly
executory2143723executory
extort13513973_extort
factor11911453factor_
factors12912123factors
feretory1447503feretory
fetor81214533fe_tor_
fetors91014473fe_tors
gentry103410443gent_ry
hectare1238463hectare
hectored1436873hectored
helotry1345653helotry
herstory1446693herstory
hickory1943903hickory
history1339423history
lactary1237843lactary
lechery15257643lechery
lectern937033lectern
lecture9149513lecture
lictor83610853lictor_
lictors93212583lictors
locutory1344273locutory
memory1338803me_mory
mentor8414363mentor_
mentors9314993mentors
nectar838853nectar_
nectars938463nectars
nestor63713413nestor_
nestors73614953nestors
oratory1039403oratory
peccary1636283peccary
pectoral121210503pectoral
peltry11288653pelt_ry
preceptory1945473preceptory
predatory1547703predatory
prefatory1746683prefatory
prestore104217343prestore
pretor8315743pre_tor_
pretors9316803pre_tors
proctor11310433proctor_
proctors12311493proctors
protectory17157483protectory
raptor83912823raptor_
raptors94213353raptors
readorn8310463readorn
realtor73611353realtor_
realtors82811683realtors
rebody1238153re_body
rebore86625643re_bore
reborn810016953re_born
rebury11349213re_bury
recency1438623recency
receptor1256693receptor_
receptors1356913receptors
rechart12314323rechart
rechose121312043rechose
reciter94117263reciter_
reciters102613113reciters
reckon123010543recko_n
reckons13269653reckons
recoal84117973rec_oal
recoat84024273rec_oat
recock145112723rec_ock
recode93618713rec_ode
recoil84016723rec_oil
recoin84320293rec_oin
recolor978693recolor_
recolors1078813recolors
recomb1238873rec_omb
recon75624243rec_o_n
recons84922993rec_ons
recook125513923rec_ook
recooks134711233recooks
records105213923rec_ords
recorks134813023rec_orks
recoup10810373rec_oup
recovery16366213recovery
recross989833recross
recrown12257573recrown
recta74220263rect__a
rectal84418133rect_al
rectally1339713rectally
recti73619623rect__i
rectorate11411353rectorate
rectorial11119893rectorial
rectories11314643rectories
rectrix1645353rectrix
rectum103411283rect_um
rectums11338523rectums
rectus83314633rect_us
recur74116843rec_ur_
recurs83315803rec_urs
redactor1147023redactor_
redactors1247533redactors
redry94314363re__dry
redtop937973redto_p
redtops1037373redtops
reductor1156433reductor_
reductors1246523reductors
reentry1038033reentry
reform11312703re_form
refractory18134773refractory
refry114412463re__fry
rejector17237723rejector_
rejectors18247613rejectors
relator74016363relator_
relators83316113relators
remarry1235193remarry
remora8414583re_mora
renter64527413renter_
renters74224813renters
repertory1445493repertory
report85326013re_port
rescore95616193rescore
resorb84914343re_sorb
resort65728613re_sort
restart7320033restart
rester63832433rester_
resters74130403resters
restock1338673restock
restoke116113903restoke
restoral8810983restoral
restored96417193restored
restorer84813723restorer
restores85222983restores
restudy1144763restudy
retard75018933re_tard
retiary1038333retiary
retire64927013re_tire
retold73013753re_told
retook104313443re_took
retool63914483re_tool
retorts76016513re_torts
retro55020953re_t_ro
retros63820193re_tros
return623222523re_turn
revelry1335693revelry
revery124014213re_very
revisory14306013revisory
reword106321403re_word
rewore938030153re_wore
rework136619783re_work
reworn98122193re_worn
rhetor938063rhetor_
rhetors1038513rhetors
robotry1244163robotry
rockery16439253rockery
rogatory1246143rogatory
rotary92411303r_otary
rotatory1147203rotatory
rotor55519733r_otor_
rotors64917933r_otors
secretory1444593secretory
sectoral10109543sectoral
sectored1138063sectored
sensory10329083sensory
sentry92912053sent_ry
story86723033__story
succory1444643succory
tory75840543___tory
tractor9311333tractor_
tractors10312553tractors
trajectory2252563trajectory
vectored1435623vectored
vestry1238623vest_ry
victor113210673victor_
victors123311173victors

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.1531167915.0
2DLD Change Limit1340272387.95616846.0
3Display Results2382380.0902644.4
 (SQL Overall)1786912388.19921794.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.