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

154 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
thenages1210748(None) 
thanages12107621thanages
thenage11107841thenage_
henges104516462_hen_ges
menages103615392_menages
phenates13611582phenates
tannages9228962tannages
teenage8108052teenage_
teenaged10105132teenaged
teenager9115292teenager
teenagers10114492teenagers
tenaces92814512t_enaces
tentages91011042t_entages
thanage11117942thanage_
thenars10248522thena_rs
tonnages9187872tonnages
tunnages9195902tunnages
alienages1045973alienages
apanages1137013apanages
avenges1157543aven_ges
averages1249183averages
benames112814603_benames
brewages1436383brewages
carnages11312213carnages
changes134517583chan_ges
chantages1546583chantages
chelates132713843chelates
coinages11310803coinages
cozenages2194693cozenages
dunnages10154933dunnages
enates64026433__enates
encages103313783__encages
engages92912493__engages
enrages83114853__enrages
ethenes103313873ethen__es
fenagles12186083_fenagles
gheraoes1244813gheraoes
grenades1038433grenades
heaves124120303_he_aves
hedges115016263_he_dges
henbanes1336573_henbanes
henge94819833_hen_ge_
henries102718283_henries
herbages1437093_herbages
hexades18378703_hexades
hexanes17319463_hexanes
hinges105121033_hin_ges
homages131011583_homages
innages82911303_innages
keelages1335743keelages
khanates1535733khanates
linages8813173_linages
lineages979183lineages
maenades1137473maenades
manages103418963_manages
menaces112715523_menaces
menage93216543_menage_
metages102714973_metages
nonages8313843_nonages
ohmages13115093oh_mages
overages12513833overages
pawnages1435313pawnages
peages94321853_pe_ages
peerages1189893peerages
pelages10714613_pelages
penates93321603_penates
peonages1138473peonages
phages125213513ph__ages
phenate12412203phenate_
phenixes2035643phenixes
phonates13410643phonates
prenames12311643prenames
presages11312203presages
reengages1145343reengages
renames92418053_renames
reneges82513593_reneges
seepages1137283seepages
senates73322613_senates
sewages1139753_sewages
sheaves134412973she_aves
signages1037483signages
spinages11289293spinages
steerages1046493steerages
taeniases944333taeniases
tallages92312003tallages
tanager83010943t_anager
tanagers9259003t_anagers
tankages13217113tankages
tannage8209583tannage_
tannates81911953tannates
tapenades1245063tapenades
teases65426273t_e_ases
tenace82715693t_enace_
tenails73713923t_enails
tenants7311013t_enants
tenches123515523t_enches
tenge65720443t_en_ge_
teniases838623t_eniases
tennies73017973t_ennies
tenses64722553t_en_ses
tentage81010643t_entage_
tenues63816443t_en_ues
tenures7412013t_enures
texases1437573t_exases
thanatos1165123thanatos
thanes94918983th__anes
theater104014253the_ater
theaters114211903the_aters
theatres11298633theatres
thebaines1454963thebaines
thebes115914493the__bes
thecae11299653theca_e_
thecate123210023thecate_
thegns10547433the__gns
theines104013233the_ines
themes115319253the__mes
thenal92712423thena__l
thenar92610003thena__r
thence112010843then_ce_
thens85921833then___s
theories11311593theories
therapies1447723therapies
theres96525473the__res
thermes126214613the_rmes
theses96517973the__ses
thetas93011573theta__s
theurgies1343353theurgies
things104914303thin_g_s
thionates12106663thionates
thirlages1343763thirlages
thonged12376843thon_ged
thongs104611193thon_g_s
thoraces13118943thoraces
thoraxes1896363thoraxes
thraves13469713th_raves
threnodes1354963threnodes
tillages93011263tillages
tinges74722333t_in_ges
toenails847213toenails
tollages92410193tollages
tonnage8168053tonnage_
towages1139233t_owages
trenails869843trenails
trenches133512603trenches
trendies9312213trendies
triages82613793t_riages
tunnage8166373tunnage_
tutelages1044013tutelages
twenties1137503twenties
twinges11409453twin_ges
venges104015153_ven_ges
ventages12119773_ventages
whenas124610463whena__s
whinges143610633whin_ges

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.420425454.8
2DLD Change Limit1461621546.94021060.8
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.42024082.3
 
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.