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 “sorceries” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
sorceries114993(None) 
forgeries13310002forgeries
groceries1249502groceries
merceries13410042merceries
orreries8310122_orreries
sorcerer1036432sorcer_er
sorcerers1145322sorcerers
sorceress1144012sorceress
sorcerous1145912sorcerous
spiceries1349312spiceries
surgeries10311362surgeries
archeries14411223_archeries
arteries8321483_arteries
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
botcheries1746053botcheries
boweries13312293bo_weries
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
corries94026793cor__ries
corsetries1249653corsetries
coteries10422703co_teries
crockeries1857113crockeries
dodgeries1246593dodgeries
doggeries1246673doggeries
doweries12411933do_weries
ferneries1239043ferneries
fooleries1248743fooleries
fopperies1666013fopperies
forcers124215713forcer__s
gorgerins1145193gorgerins
hosieries1249213hosieries
jobberies20115423jobberies
joineries1648103joineries
larcenies1147533larcenies
lorries74518343lor__ries
lotteries9311073lotteries
mercerise1356413mercerise
mercerises1446193mercerises
mercerizes2346053mercerizes
mercuries1347273mercuries
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873mo_peries
nurseries948013nurseries
orceins937743_orce_ins
orderlies1045453_orderlies
ornerier846043_ornerier
orneriest947403_orneriest
poperies12316793po_peries
potteries11313593potteries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
roperies10315763ro_peries
roseries8317313ro_series
sceneries1149393sceneries
scries85226823s__c_ries
sealeries9313133sealeries
secrecies1346913secrecies
series64540973s___eries
serries73925353ser__ries
slaveries1249683slaveries
snobberies1444083snobberies
soberizes2098963so_berizes
sobrieties1244293sobrieties
soccers1138393soccer__s
societies1148803societies
soldieries1145593soldieries
sorceresses1343373sorceresses
sorcery1237033sorcer__y
sorners73416873sorner__s
sorrier72313733sor__rier
sorriest8413883sor__riest
sorters74221133sorter__s
sorties74126403sor__ties
spooferies1543703spooferies
spookeries1654293spookeries
subseries11312933subseries
succories1347183succories
surceases1157473surceases
sureties8316583sur_eties
toggeries1146213toggeries
torcheres1446863torcher_es
torrefies12114753torrefies
traceries11312863traceries
turneries948493turneries
voleries11313233vo_leries
worries104117133wor__ries

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641926.92321470.6
3Display Results92920.0303066.7
 (SQL Overall)178691927.37624226.0
 
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.