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

136 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
atop6612475(None) 
atap66722451atap
atom67824521atom
atopy106813391atopy
stop66532031stop
top510560681_top
abo59045962abo_
abos67734412abos
actor71116082actor
ado49146872ado_
adopt81219742adopt
ados57633512ados
aeon45634612aeon
ago48845522ago_
agog68019002agog
agon56531882agon
ahoy101919182ahoy
aloe45540192aloe
alow75328592alow
alp56641132a_lp
alto47831262alto_
altos55822952altos
amok10217402amok
amp77541022a_mp
anoa45634472anoa
anon46134852anon
apo511142122apo_
apod78123182apod
apos65433822apos
app76827602a_pp
asp57235342a_sp
at212393402at__
ataps76414832ataps
ate37059242at_e
ates45047922ates
atma68121772atma
atoll57913922atoll
atoms76817562atoms
atomy107415192atomy
atone56527982atone
atony87218852atony
atopic103514142atopic
atrip75315752atrip
att35454652at_t
auto47432082auto_
autos56523322autos
avo68936232avo_
avos77227012avos
avow107816462avow
awol75620672awol
axon115524302axon
azo128233392azo_
azon135725052azon
baton75822422baton
bop77549482_bop
cartop104213562cartop
chop116024922chop
clop86929892clop
coop87238652coop
cop711162372_cop
crop87628632crop
dato56129942dato_
datos65222782datos
drop75324402drop
estop74312102estop
flop96925452flop
fop86743702_fop
galop84716222galop
gator64416042gator
glop76724632glop
goop75829482goop
hoop96129982hoop
hop87554592_hop
jalop144212602jalop
jato115822682jato_
jatos125116822jatos
knop107116592knop
kop97440202_kop
laptop1076812laptop
loop67835012loop
lop58255312_lop
mop76950822_mop
netop7312342netop
op45850162__op
plop86625742plop
poop86532812poop
pop76252252_pop
prop85932812prop
ragtop936682ragtop
rato45436972rato_
ratos55528762ratos
scop85925522scop
shop95629842shop
slop66533872slop
sop57557862_sop
step67126292step
stoa45425912stoa
stob66724612stob
stomp95616662stomp
stoop75821542stoop
stope74727242stope
stops74827282stops
stopt76528352stopt
stot46347332stot
stoup75517072stoup
stow77325742stow
stowp105614232stowp
strop77422242strop
swop95120502swop
tamp86133012tamp
tao38358952tao_
taos45541002taos
tap57663882_tap
tarp66936422tarp
tip56551222_tip
to218858982_to_
tod49457072_tod
toe310166852_toe
tog410255042_tog
tom514358052_tom
ton310265102_ton
too38965422_too
tope65946382_tope
toph96326872_toph
topi67830392_topi
topo66932402_topo
tops66248122_tops
tor39261682_tor
tot38884772_tot
tow610557362_tow
toy69655192_toy
trop66833302trop
tup56037542_tup
watap102111672watap
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.266671770.7
2DLD Change Limit298721360.92332364.0
3Display Results1361360.0304533.3
 (SQL Overall)1786911361.219146588.2
 
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.