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

135 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
countries1131361(None) 
counties10316281count_ies
bounties10311402bount_ies
chantries14310292chantries
contrives14311702co_ntrives
coonties10513802coont_ies
coquetries2146022coquetries
foundries1345692foundries
gauntries1046032gauntries
poultries1148452poultries
upcountries1552012upcountries
agentries1048233agentries
aunties73920073_aunt_ies
boundaries1345113boundaries
bountied1136333bount_ied
bourtrees11154013bourtrees
canaries10318943c_anaries
canneries11313083canneries
cantrips12318933c_antrips
causeries11510643causeries
cauteries11615393cauteries
centres93817123c_entr_es
centuries11311333c_enturies
chanties132615803chant_ies
clowneries1544733clowneries
coenures1048683coenur_es
coistrils1146423coistrils
comities12317793comit_ies
conchies153214853co_nchies
congeries12316403congeries
conies84338593co_n__ies
construes11410133construes
contains10316533co_ntains
contes84432913co_nt__es
contrails11410543co_ntrails
contraries12711933co_ntraries
contras93015623co_ntr_as
contrite10318543co_ntrite
contrive13311353co_ntrive
contrived1547993co_ntrived
contriver1448343co_ntriver
contrivers1547253co_ntrivers
controls10311393co_ntrols
contuses10413453co_ntuses
cookeries151210633cookeries
coontie9311423coont_ie_
cooperies131113313cooperies
cooties93725733co_ot_ies
corncribs1542963corncribs
cornetcies1445843cornetcies
cornifies1439003cornifies
coronaries12410233coronaries
corries94026793co__rries
corsetries1249653corsetries
coteries10422703co_teries
coumarins1347023coumarins
councils1246973coun_cils
counted103815803count__ed
counter94220153count__er
counterbids1646033counterbids
countercries1648993countercries
countered12313003countered
counterfires1747063counterfires
countering13314473countering
counterion1249533counterion
counterions1349823counterions
countermen1449293countermen
countermines1649153countermines
counters103320193count_ers
counterspies1648313counterspies
countersues1348533countersues
counterview19116683counterview
counterviews20134873counterviews
countess103710053count_ess
countesses1248843countesses
countian1048123count_ian
countians1147333countians
counting113115273count_ing
countless1146373countless
countrified1754113countrified
country12388043countr__y
countryfied2052433countryfied
countryish1852853countryish
countrymen1753893countrymen
countrysides1852053countrysides
counts84618273count___s
courier93617893cou__rier
couriers103213173cou__riers
courses94218893cou__rses
courtesies1246453courtesies
courtier1059333court_ier
courtiers1146693court_iers
courtlier1154463courtlier
courtliest1244903courtliest
courtsides1343583courtsides
cousinries1244693cousinries
couthie121810553cou_thie_
couthier13218913cou_thier
couthiest1439403cou_thiest
coutures10311993cou_tures
couturier1145423couturier
couturiers1243853couturiers
covaries13413253co_varies
cowries124218013co__wries
curies84934023c_u__ries
curries93723163c_u_rries
curtsies1038733c_urtsies
cuties84927363c_u_t_ies
cutties93118843c_u_tties
entries71523163__entries
fountains1245283fountains
gantries91413783_gantries
gentries91315263_gentries
joineries1648103joineries
laundries1045563laundries
mountains1146363mountains
nonentries1048283nonentries
outcries10313573_outcries
outlies72421993_ou_tlies
outrides92414993_ou_trides
outrigs82811263_ou_trigs
outvies102214243_ou_tvies
pantries101817393_pantries
poetries10315583po_etries
punties94520783_punt_ies
reentries9311763reentries
robotries1147323robotries
roundtrips1351893roundtrips
sentries81318053_sentries
sundries9312023_sundries
truantries1044023truantries
unties64326923__unt_ies
untried82615853__untried
untrims938613__untrims
voluntaries1454123voluntaries

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.1731032896.0
2DLD Change Limit1486411357.56319653.7
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.79922912.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.