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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

100 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
knop10711659(None) 
knap105815401knap
knob107417011knob
knops115911811knops
knosp11576821knosp
knot85630501knot
know116115841know
kop97440201k_op
anoa45634472anoa
anon46134852anon
atop66124752atop
bop77549482_bop
chop116024922chop
clop86929892clop
coop87238652coop
cop711162372_cop
crop87628632crop
drop75324402drop
enol45823822enol
enow77819872enow
flop96925452flop
fop86743702_fop
glop76724632glop
goop75829482goop
hoop96129982hoop
hop87554592_hop
kaon87521022kaon
keep106329812keep
kelp105322802kelp
kemp126418762kemp
keno87926432keno_
kenos95220622kenos
kep96437202k_ep
kino86233612kino_
kinos96626142kinos
kip97042132k_ip
knaps115511172knaps
knar85818722knar
knee85323602knee
knew115912122knew
knit85728142knit
knobs11519712knobs
knock10487962knock
knoll9389602knoll
knosps12405012knosps
knots95614722knots
knout95018262knout
known12568342known
knows124912412knows
knur85311972knur
koa76737772k_oa
kob99442382k_ob
koi77534742k_oi
konk79320612konk
kook75822602kook
koph135816542k_oph
kops107031292k_ops
kor76538892k_or
kos76944822k_os
loop67835012loop
lop58255312_lop
mop76950822_mop
nap56753202_nap
nip56945982_nip
no29353242_no_
nob58954422_nob
nod47549562_nod
nog46847312_nog
noh66640642_noh
nom510450642_nom
noo37154042_noo
nope65934192_nope
nor38048822_nor
nos38859322_nos
not39474662_not
now65950192_now
ono36838032ono_
onos46229002onos
op45850162__op
plop86625742plop
poop86532812poop
pop76252252_pop
prop85932812prop
scop85925522scop
shop95629832shop
slop66533872slop
snap65727032snap
snip66424652snip
snob65825592snob
snog55623632snog
snoop75317172snoop
snot44745442snot
snow76324792snow
sop57557862_sop
stop66532032stop
swop95120502swop
top510560682_top
trop66833302trop
whop125520922whop
wop87145132_wop

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 Filter178691298720.0762351197.4
2DLD Change Limit298721001.00029872.0
3Display Results1001000.0462173.9
 (SQL Overall)1786911001.122159261.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.