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

178 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
tonnages918787(None) 
tannages9228961tannages
tonnage8168051tonnage_
tunnages9195901tunnages
bondages1237892bondages
coinages11310802coinages
dunnages10154932dunnages
innages82911302_innages
montages111412182montages
nonages8313842no_nages
tankages13217112tankages
tannage8209582tannage_
tannates81911952tannates
tentages91011042tentages
thanages12107602thanages
thenages12107472thenages
tollages92410192tollages
tonnes65320852tonn__es
towages1139232to_wages
tunnage8166372tunnage_
anlages82414103_anlages
annates72415423_annates
apanages1137013apanages
bandages12310633bandages
bondage1138253bondage_
bonnes85621453bonn__es
borages103917163bo_rages
boscages1366643boscages
boskages1565423boskages
carnages11312213carnages
cognates11311573cognates
coinage10310553coinage_
collages113514233collages
comanages1446533comanages
concaves1538903concaves
conges94928173co_n_ges
connate9315753connate_
connives1339723connives
connotes10311453connotes
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
cottages113310493cottages
courages11311393courages
cowages13310933co_wages
cowhages1736103cowhages
cozenages2194693cozenages
dockages1635983dockages
donates83217223do_nates
donnas75511323donna__s
donnees84210363donn_ees
dosages92310803do_sages
dotages92311793do_tages
dunnage9175213dunnage_
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
foggages1434213foggages
foliages1247623foliages
footages1239043footages
forages114217273fo_rages
frontages13116183frontages
homages131011583ho_mages
hostages122311693hostages
incages103013883_incages
innage73011573_innage_
jobnames1942873jobnames
linages8813173_linages
lineages979183lineages
linkages1385953linkages
lockages1536723lockages
longes75925573lo_n_ges
lounges84811353loun_ges
lovages1138033lo_vages
manages103418963_manages
menages103615393_menages
mintages111110513mintages
monades103713823mo_nades
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139043moorages
moulages1138053moulages
nonage7313683no_nage_
nonimages1244823nonimages
nontaxes1537853nontaxes
nonwage1137163nonwage_
ohmages13115093_ohmages
onager739663_o_nager
onagers838103_o_nagers
oranges84215333_oranges
outages82317323_outages
pawnages1435313pawnages
pennames12287783pennames
peonages1138473peonages
pinnaces12268863pinnaces
portages112613223portages
postages112815323postages
potages102416423po_tages
pottages112910453pottages
poundages1344153poundages
rennases848983rennases
rootages939093rootages
signages1037473signages
sinkages1386853sinkages
soakages1336143soakages
socages101012053so_cages
soccages1336383soccages
soilages9189673soilages
sonances10310263sonances
sonnies7315223sonn_ies
spinages11289293spinages
stockages1644923stockages
stoppages1444693stoppages
storages9311103sto_rages
stowages1236473sto_wages
tallages92312003tallages
tanager83010943t_anager
tanagers9259003t_anagers
tankage12257773tankage_
tannate71813523tannate_
teenage8108053teenage_
teenaged10105133teenaged
teenager9115293teenager
teenagers10114493teenagers
tenaces92814513t_enaces
teniases838623teniases
tennies73017973tenn_ies
tennises82810133tennises
tentage81010643tentage_
thanage11117933thanage_
thenage11107833thenage_
tillages93011243tillages
tinges74722323t_in_ges
tinwares1137903tinwares
toenails847213toenails
tolanes74216303to_lanes
tollage82610163tollage_
toluates8138893toluates
tonearms1044713tonearms
tonemes9311683to_nemes
tones56048663to_n__es
tonettes839203tonettes
tongas74315513to_n_gas
tonged86518903to_n_ged
tonger74719683to_n_ger
tongers84116013to_n_gers
tongs65928463to_n_g_s
tongues879693to_ngues
tonne54921433tonn__e_
tonneaus853913tonneaus
tonner64819203tonn__er
tonners73816403tonn_ers
tonsures869133tonsures
tontines82114733tontines
tonuses73612193to_nuses
toonies73719883toon_ies
topazes1857313to_pazes
tornadoes1044283tornadoes
tornados945353tornados
torsades937203torsades
towage1039833to_wage_
townees10269783town_ees
townies103113623town_ies
triages82613793t_riages
tunnies73614263tunn_ies
twinges11409443twin_ges
uncages103213773_uncages
vantages12119023vantages
ventages12119763ventages
vintages12118273vintages
voltages1237253voltages
vorlages1236033vorlages
voyages1435703vo_yages
wannabes1344473wannabes
wantages12109023wantages
windages1338263windages
wordages1337053wordages

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.1701051123.5
2DLD Change Limit1461621787.12620511.1
3Display Results1781780.0762342.1
 (SQL Overall)1786911787.37224239.1
 
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.