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

176 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
orreries831012(None) 
arteries8321482arteries
forgeries13310002forgeries
orderlies1045452orderlies
ornerier846042ornerier
orneriest947402orneriest
roperies10315762roperies
roseries8317312roseries
sorceries1149932sorceries
torrefies12114752torrefies
aeries64737783__aeries
amberies122514683amberies
aperies9423203_aperies
archeries14411223archeries
armories10313653armories
bakeries14312193bakeries
barretries1246243barretries
berries94423553ber_ries
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
borrelias1144303borrelias
boweries13312293boweries
braveries1439103braveries
breweries1447583breweries
briberies1348333briberies
carries94328013car_ries
celeries10316313celeries
cherries131812983cherries
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
corries94026803cor_ries
corrodies1247903corrodies
corsetries1249653corsetries
coteries10422703coteries
creepies1239613creepies
currieries1244533currieries
curries93723163cur_ries
derries83124623der_ries
dodgeries1246593dodgeries
doggeries1246673doggeries
doweries12411933doweries
draperies1249193draperies
drearies92313413drearies
duperies11312813duperies
durries83817353dur_ries
eateries8324313eateries
emeries91620023_emeries
emperies12314563emperies
faeries104118993_faeries
fakeries1559833fakeries
farrieries1344343farrieries
ferneries1239043ferneries
ferries103521083fer_ries
fineries112416743fineries
fooleries1248743fooleries
fopperies1666013fopperies
freebies1337873freebies
freres94716173_frer_es
friaries11310083friaries
furrieries1343943furrieries
gorgerins1145193gorgerins
graperies1239613graperies
greenies9312673greenies
groceries1249503groceries
gurries83515953gur_ries
harries103525493har_ries
heresies11312693heresies
herries104025073her_ries
horrifies15146393horrifies
hosieries1249213hosieries
hurries103919653hur_ries
japeries17311463japeries
jerries143817513jer_ries
jobberies20115423jobberies
joineries1648103joineries
kerries113317913ker_ries
liveries11314373liveries
lorries74518353lor_ries
lotteries9311073lotteries
marries93825283mar_ries
merceries13410043merceries
miseries10320403miseries
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873moperies
murries94118673mur_ries
naperies10313903naperies
niteries8318383niteries
nurseries948013nurseries
observes1346173observes
obverses1335803obverses
ogresses938473ogresses
onerier7311613o_nerier
oneriest8313443o_neriest
oogenies9311583oogenies
orangeries11116943orangeries
oratories9410653oratories
oratrices1145833oratrices
orceins937743orce_ins
ordered9108533order_ed
orderer8127943order_er
orderers9116563orderers
ordering1039353ordering
orderless1044313orderless
orders74315993order__s
ordures856473ordur_es
oreides8312023o_reides
orgies72316093o_r_gies
ormers84316143ormer__s
orneriness1045443orneriness
orogenies10410533orogenies
orrery936783orrer__y
orrices9129363orr_ices
orris54516553o_r_ri_s
orrises71312233orr_ises
ouraris73512933ourari_s
ourebis936123ourebi_s
outcries10313573outcries
ovaries10312653o_varies
overdries13310883overdries
overlies112417043overlies
overrides131411013overrides
parries93925843par_ries
peeries93623023_peeries
perries93226603per_ries
pineries102419083pineries
poperies12316793poperies
potteries11313593potteries
prairies10411453prairies
predries112714383predries
preemies12512193preemies
premies113823063_premies
prexies163415003_prexies
priories10312453priories
pruderies1247873pruderies
queries16315873_queries
rarefies1138993rarefies
rareripes1165353rareripes
redries83721713_redries
refries104419733_refries
relies65036423__relies
rerigs74014793__rerigs
rerise64325633__rerise
rerises73525883__rerises
reties65436193__reties
retries74129073_retries
reveries112518513reveries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
rosaries8312783rosaries
rotaries8315693rotaries
ruderies9311333ruderies
series64540973__series
serries73925353ser_ries
sherries111812893sherries
skerries12168673skerries
sureties8316583sureties
surgeries10311363surgeries
tarries73324263tar_ries
terries73425633ter_ries
toggeries1146213toggeries
torrefied13143053torrefied
torrifies12137033torrifies
traceries11312863traceries
turneries948493turneries
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
voleries11313233voleries
wherries14179023wherries
wineries112316533wineries
worries104117133wor_ries

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621766.47022590.7
3Display Results1761760.0762315.8
 (SQL Overall)1786911766.98225593.1
 
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.