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 “counts” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
counts8461827(None) 
count74932051count_
county114313321county
courts84216171courts
cunts76125121c_unts
founts94313381founts
mounts84115071mounts
accounts1285842accounts
amounts937042amounts
aunts55227632_aunts
blunts84512892blunts
bounds94415802bounds
bounty113411072bounty
bouts75131312bou_ts
brunts85215452brunts
bunts75729802_bunts
cants77036942c_ants
cents74730332c_ents
chants115020392chants
chaunts1267082chaunts
chints115117832chints
chunks154210332chunks
clouts87017202clou_ts
clunks124811012clunks
coacts105314332coacts
coapts104614012coapts
coasts85719142coasts
coats75635002co_ats
cobnuts1135352cobnuts
cohunes1249712cohunes
coins75834552coin_s
colts76633292co_lts
comets105823582comets
compts125216652compts
cones76457422co_nes
conks115525702co_nks
conns75024232co_nns
cons66057692co_n_s
conte76633202co_nte
contes84432912co_ntes
conto76027172co_nto
contos84923232co_ntos
conus76726532co_nus
coons76737282coon_s
coopts105814582coopts
coots75636842co_ots
coquets18399892coquets
cornets94820572cornets
corns76034762corn_s
cornus84816562cornus
cosets85824402cosets
costs77231142co_sts
cots68054842co__ts
coughs125514542coughs
coulis84018762coulis
counted103815802counted
counter94220152counter
counters103320192counters
countess103710052countess
counties10316282counties
country12388042country
coupes105022522coupes
coups95522472cou_ps
courants10310802courants
court75532772court_
couth106122492cou_th
couths115715412couths
covets114819642covets
cruets85314952cruets
crusts84916542crusts
cults75022552c_ults
cunt66243672c_unt_
cuts65841152c_u_ts
daunts75014082daunts
donuts7410582donuts
doubts968732doubts
dunts65828412_dunts
fonts86124752fo_nts
founds104814192founds
fount84727032fount_
gouts64826172gou_ts
grunts75511852grunts
haunts95614392haunts
hounds104413132hounds
hunts86826172_hunts
jaunts137511882jaunts
joints133811452joints
jousts135011272jousts
louts56330272lou_ts
lunts55826902_lunts
moults84713702moults
mounds93915132mounds
mount74128062mount_
nouns56717312noun_s
ousts55225702_ousts
outs45746962_ou_ts
points85618532points
poults84613482poults
pounds93714382pounds
pouts75530322pou_ts
punts75828002_punts
recounts1038772recounts
rounds73615622rounds
rousts617016722rousts
routs57133412rou_ts
runts55927632_runts
scouts84817942scou_ts
shunts95712022shunts
sounds74616182sounds
stunts65615252stunts
taunts65715662taunts
touts54830392tou_ts
vaunts95212622vaunts
wonts87621542wo_nts
wounds103811632wounds
youngs1035382youngs
zounds164310172zounds

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511172.68630733.8
3Display Results1171170.0333545.5
 (SQL Overall)1786911173.07958035.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.