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

143 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
dunnage917521(None) 
dunnages10154931dunnages
tunnage8166371tunnage
dunnite857332dunnite
innage73011572_innage
tannage8209582tannage
tonnage8168052tonnage
tunnages9195902tunnages
uncage93014872_uncage
aduncate1145573aduncate
anlage72514233_anlage
apanage1036803apanage
bandage11311023bandage
bondage1138253bondage
bulkage1435703bulkage
buoyage1344293buoyage
burgage1136633burgage
carnage10311743carnage
coinage10310553coinage
connate9315753connate
cubage1178273cu_bage
cuneate9311723cuneate
cuttage10318343cuttage
damage10410773d_amage
degage92711383d_egage
dentate8315153dentate
derange939813derange
dinge75627303d_in_ge
dockage1535723dockage
donate73619503d_onate
donna66215033donna__
donnas75511323donna_s
donne65520463donn__e
donnee74317063donn_ee
dosage82810003d_osage
dotage82711613d_otage
drainage1045783drainage
drayage1234423drayage
duende836923duen_de
duenna734593duenna__
duennas834143duenna_s
dunam8313733du_na_m
dunams937833du_nams
dunce86319263du_n_ce
dune56137583du_n__e
dung66328433du_n_g_
dungaree1045613dungaree
dunged95414693du_n_ged
dungs75821973du_n_gs
dungy104713643du_n_gy
dunite7315013du_nite
dunned85015523dunn_ed
dunner73913823dunn_er
dunness8298983dunness
dunnest83312263dunnest
dunning93514473dunning
dunnites947173dunnites
durance1059113durance
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
furnace1235943furnace
guanase836213guanase
gunwale1134733gunwale
incage93513623_incage
innages82911303_innages
innate63917313_innate
linage7713403_linage
lineage878983lineage
linkage1295963linkage
luggage1043673luggage
lunate6316043lu_nate
lunge65323803lu_n_ge
manage93818903_manage
menage93216543_menage
mintage101110123mintage
montage101211713montage
mundane1038073mundane
nonage7313683_nonage
nonwage1137163nonwage
outage72017533ou_tage
outrage82616893outrage
pawnage1335873pawnage
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
peonage1048723peonage
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
poundage1244023poundage
quayage2044573quayage
quinate16511573quinate
rennase738713rennase
ruinate7312833ruinate
rummage1234583rummage
signage937773signage
sinkage1287263sinkage
spinage10289653spinage
sullage859913sullage
sundae7312873sunda_e
sunna55016063sunna__
sunnah9369353sunna_h
sunnahs10326593sunnahs
sunnas63914563sunna_s
surname937603surname
tankage12257773tankage
tannages9228963tannages
tannate71813523tannate
teenage8108053teenage
tentage81010643tentage
thanage11117943thanage
thenage11107843thenage
tonnages9187873tonnages
ullage739043_ullage
ulnae55214573_ulna_e
unaged83916423_u_naged
unbale83616403_unbale
uncaged113314123_uncaged
uncages103213773_uncages
uncake122813523_uncake
uncase83817433_uncase
uneager839753_uneager
unease63816643_unease
unitage838993_unitage
unlace82215173_unlace
unlade72714153_unlade
unmade92911063_unmade
unmake122811213_unmake
unnail6410583_unnail
unnamed102410273_unnamed
unpaged113311043_unpaged
unsafe9310693_unsafe
unsnag736393_unsnag_
unsnags835463_unsnags
untame82513603_untame
usage6410213_u_sage
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
wannabe1234533wannabe
wantage11119623wantage
windage1237933windage

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271436.25021444.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.71926594.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.