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

126 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
count7493205(None) 
counts84618271counts
county114313321county
court75532771court
cunt66243671c_unt
fount84727031fount
mount74128061mount
account11109042account
amount8414482amount
aunt46553652_aunt
blunt75525022blunt
bound84819582bound
bounty113411072bounty
bout66353292bou_t
brunt75728752brunt
bunt65850852_bunt
cant66362032c_ant
cent67451012c_ent
chant105932692chant
chaunt11613492chaunt
chunk144812382chunk
clout75330462clou_t
clung86013602clung
clunk114215082clunk
coact96130582coact
coapt96131532coapt
coast75236272coast
coat67558352co_at
cobnut10311322cobnut
coft97939682co_ft
cogent9321002cogent
cohune1189422cohune
coin66645352coin_
coins75834552coins
colt67158242co_lt
comet95946072comet
compt116328222compt
con510268022co_n_
cone67256962co_ne
coni65534802co_ni
conk106531442co_nk
conn66229132co_nn
conns75024232conns
cons66057692co_ns
conte76633202co_nte
conto76027172co_nto
conus76726532conus
cony96537832co_ny
coon67248942coon_
coons76737282coons
coopt95929852coopt
coot67860382co_ot
coquet174318012coquet
corn69945812corn_
cornet84436732cornet
corns76034762corns
cornu75921322cornu
corny106023272corny
coset75748842coset
cost68057942co_st
cot510483222co__t
couch125320112couch
coude85022632coude
cough115819642cough
could86517712could
counted103815802counted
counter94220152counter
country12388042country
coup86729792cou_p
coupe96023482coupe
coups95522472coups
courant9317972courant
courts84216172courts
couth106122492couth
covet105638942covet
cruet74831842cruet
crust75827662crust
cult66541152c_ult
cunts76125122c_unts
curt67051712c_urt
cut57957662c_u_t
daunt65929082daunt
donut6324512donut
doubt8720092doubt
dunt55746872_dunt
font77143752fo_nt
found94917842found
founts94313382founts
gaunt65430402gaunt
gout56646002gou_t
grunt65523542grunt
haunt85229132haunt
hound95016482hound
hunt76445492_hunt
jaunt125025272jaunt
joint125227722joint
joust125122292joust
lout45952142lou_t
lunt46148842_lunt
moult74728722moult
mound83918312mound
mounts84115072mounts
noun45724182noun_
nouns56717312nouns
oust46747442_oust
out38072152_ou_t
point75338732point
poult76928872poult
pound84417862pound
pout65752552pou_t
punt65747202_punt
recount9315172recount
round64318432round
roust55532062roust
rout46153282rou_t
runt46647992_runt
scout75031452scou_t
shunt85226512shunt
sound64420022sound
stunt55328172stunt
taunt55532282taunt
tout46753822tou_t
vaunt85925312vaunt
wont75842502wo_nt
wound94414212wound
young977742young

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001261.46636698.5
3Display Results1261260.0333818.2
 (SQL Overall)1786911261.81298615.3
 
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.