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

152 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
lockages153672(None) 
blockages1844061blockages
dockages1635981dockages
lockage1436611lockage_
blockades1844112blockades
blockage1744102blockage_
boskages1565422boskages
brockages1844782brockages
cockades1738432cockades
corkages1539102corkages
dockage1535722dockage_
leakages1334932leakages
linkages1385952linkages
locales93715092loc_ales
locates93218812loc_ates
lovages1138032lo_vages
packages17138732packages
soakages1336142soakages
socages101012052soc_ages
soccages1336382soccages
stockages1644922stockages
blockade1744033blockade_
blockaded1943083blockaded
blockader1843113blockader
blockaders1942573blockaders
bondages1237893bondages
borages103917163bo_rages
boscages1366643boscages
boskage1465413boskage_
brockage1744743brockage_
brokages1536253brokages
bulkages1535273bulkages
cages85936013__c_ages
coccyges1542333coccyges
cockade1638133cockade_
cockaded1836393cockaded
cockeyes1967033cockeyes
cockles153414643cock_les
coinages11310803coinages
collages113514243collages
cordages12310113cordages
corkage1438373corkage_
corsages11310363corsages
cottages113310493cottages
courages11311393courages
cowages13310943co_wages
cowhages1736113cowhages
dosages92310803do_sages
dotages92311793do_tages
ecotages1136973ecotages
encages103313783enc_ages
escuages1145163escuages
floatages1344233floatages
floorages1364983floorages
flotages1237163flo_tages
flowages1535733flo_wages
foggages1434213foggages
foliages1247623foliages
footages1239053footages
forages114217283fo_rages
homages131011593ho_mages
hostages122311693hostages
incages103013883inc_ages
lactases1038523lactases
lactates10311233lactates
lavages1138603l_avages
leafages1244623leafages
leakage1235003leakage_
linages8813173l_inages
lineages979183lineages
linkage1295963linkage_
loaves94813853lo__aves
locale83915653loc_ale_
locals83714503loc_a_ls
locate83919843loc_ate_
located103114183loc_ated
locater93113603loc_ater
locaters102710073loc_aters
lochans1248833locha_ns
lockable1636953lockable
lockboxes2453453lockboxes
locked134921663lock__ed
locker124019423lock__er
lockers133516923lock_ers
locket123922473lock__et
lockets134612203lock_ets
lockjaws2441873lockjaws
lockmaker1643673lockmaker
lockmakers1743183lockmakers
locknuts1443683locknuts
lockouts1445493lockouts
lockrams1643923lockrams
locks115126923lock___s
lockset13311163lock_set
locksets1435693locksets
lockstep1643813lockstep
locksteps1743343locksteps
lockups1534243lock_ups
locoes85516583loc__oes
locules92812603loc_ules
lodges86820153lo__dges
loges66534203lo___ges
longes75925573lo__nges
lounges84811353lo_unges
lovage1037353lo_vage_
lozenges1843053lozenges
luckies133313683luck_ies
luggages1143633luggages
montages111412183montages
moorages1139053moorages
moulages1138053moulages
nonages8313843no_nages
octanes91111393_octanes
octaves12316963_octaves
ohmages13115093_ohmages
outages82317323_outages
package16128013package_
packaged18115753packaged
packager17136153packager
packagers18144683packagers
pickaxes2344913pickaxes
plottages1244243plottages
portages112613223portages
postages112815323postages
potages102416423po_tages
pottages112910453pottages
rockabies1744223rockabies
rockabyes2042493rockabyes
rootages939103rootages
sinkages1386853sinkages
soakage1236103soakage_
socage91012123soc_age_
socager10107703soc_ager
socagers1196363soc_agers
soccage1236283soccage_
sockeyes1765763sockeyes
soilages9189673soilages
stockades1644433stockades
stockage1544903stockage_
tankages13217113tankages
tollages92410193tollages
tonnages9187873tonnages
towages1139233to_wages
trackages1645343trackages
truckages1643523truckages
uncages103213773unc_ages
voltages1237253voltages
vorlages1236033vorlages
voyages1435703vo_yages
wickapes1943703wickapes
wordages1337053wordages
wreckages1942773wreckages

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621526.98320931.1
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.45223978.9
 
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.