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

168 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
country1238804(None) 
county114313321count_y
bounty113411072bount_y
chantry15388222chantry
contra83314702co_ntra
coquetry2243562coquetry
count74932052count__
counted103815802counted
counter94220152counter
counters103320192counters
counts84618272count_s
courtly1256922courtly
foundry1433912foundry
gauntry1154112gauntry
poultry1235382poultry
upcountry1651402upcountry
agentry11165753agentry
auntly95211063_auntly
aunty85919813_aunt_y
bluntly1235223bluntly
bouncy13409073boun_cy
boundary1444753boundary
canary11314693c_anary
cannery123610013cannery
canty105226803c_ant_y
cautery12349593cautery
centra84113883c_entra
centre84316643c_entre
century1237193c_entury
chantey154112543chantey
chanty145215823chant_y
chintzy24364223chintzy
chunky18468273chun_ky
chunter123911483chunter
chunters133910903chunters
chutney1533823chutney
clownery1633313clownery
clunky15447893clun_ky
clustery13317113clustery
cluttery13346323cluttery
coenure968153coenure
coenuri945463coenuri
cogently1446323cogently
coiner84323783coiner_
coiners93620753coiners
cointer93616723cointer
cointers103616423cointers
cometary1547693cometary
comity13312713comit_y
conchy163710223co_nchy
coney105932883co_n_ey
conky145818743co_n_ky
conner84423963conner_
conners94023113conners
conte76633203co_nt_e
contes84432913co_ntes
conto76027173co_nt_o
contort91422343co_ntort
contos84923233co_ntos
contrary1347493co_ntrary
contras93015623co_ntras
control9310693co_ntrol
convey144610223co_nvey
convoy14348543co_nvoy
cony96537833co_n__y
cookery164210393cookery
coontie9311423coontie
coopery143910273coopery
coppery16409393coppery
corner84625623corner_
corners94723313corners
cornetcy1544303cornetcy
cornify1536253cornify
cornily12410853cornily
corny106023273corn__y
coronary1347693coronary
corsetry1365573corsetry
cory96941513co___ry
costly114012333co_stly
cougar958783cougar_
cougars1038443cougars
coulter94115603coulter
coulters103614313coulters
council1137473council
counsel948543counsel
countably1646293countably
countercry1745093countercry
countered12313003countered
counterspy1744663counterspy
countess103710053countess
countian1048123countian
counties10316283counties
counting113115273counting
countries11313613countries
countryish1852853countryish
countryman1753573countryman
countrymen1753893countrymen
court75532773cou__rt
courted103514923courted
courter94516483courter
courters103015373courters
courtesy1364973courtesy
courts84216173court_s
cousinry1343533cousinry
couter84930223cou_ter
couters93827303couters
couth106122493cou_t_h
couths115715413cou_ths
couture9310623couture
covary1438743co_vary
cowry135512483co__wry
crunchy17324763crunchy
crusty114911343crust_y
cuatro838433c_uatro
cunt66243673c_unt__
cunts76125123c_unt_s
curry105920343c_u_rry
curtly1149283c_urtly
curtsy1156643c_urtsy
cutey105819793c_u_tey
cutty105417223c_u_tty
entry82414263__entry
fount84727033fount__
founts94313383fount_s
gantry103810113_gantry
gauntly1135333gauntly
gentry103410443_gentry
gouty95217363gou_t_y
hungry1334973_hungry
jaunty16388513jaunt_y
joinery17366593joinery
jointly1735483jointly
jouncy18336203joun_cy
laundry1133513laundry
loungy10476833loun_gy
loury85716753lou__ry
mount74128063mount__
mounted103611533mounted
mounter93713173mounter
mounters103712503mounters
mounts84115073mount_s
mouthy14409063mou_thy
noncountry1553523noncountry
nonentry1146813nonentry
onery8414123_o_nery
ornery938463_ornery
outby10411533_ou_tby
outcry1137993_outcry
outre53922203_ou_tre
pantry115014103_pantry
poetry1139383po_etry
pointy114913283point_y
pouty107018813pou_t_y
punty106021613_punt_y
reentry1038033reentry
robotry1244173robotry
roundly1136723roundly
runty86119043_runt_y
sentry92912053_sentry
soundly1136683soundly
sultry938463_sultry
sundry1057943_sundry
truantry1142543truantry
unary8315993__unary
vaunty12409063vaunt_y
voluntary1543003voluntary
wintry12498923_wintry
zonary1838793zo_nary

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.440406115.9
2DLD Change Limit1340271686.00022337.8
3Display Results1681680.0602800.0
 (SQL Overall)1786911686.50027490.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.