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

144 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
lapdog103444(None) 
lapdogs1134071lapdogs
bandog1038722bandog
laptop1076812laptop
lardon74415062lardon
ado49146873_a_do_
ados57633513_a_dos
agog68019003_a_gog
aldol61212333_aldol
aping87327233_aping
apo511142123_ap_o_
apod78123183_ap_od
apods86316343_apods
apolog938903_apolog
apos65433823_ap_os
apron7318833_apron
ardor64617863_ardor
bandogs1138363bandogs
candor94516423candor
cantdog1134573cantdog
capo85829213cap_o_
capon95221873cap_on
capos94826073cap_os
captor104914603captor
cardon94120853cardon
coydog1335133coydog
dado67126333da_do_
dados75522433da_dos
dog57449753___dog
fado87226463fa_do_
fados95620733fa_dos
fandom122110893fandom
fogdog1234223fogdog
gaping105618923gaping
gundog935793gundog
hagdon1188283hagdon
hangdog1343133hangdog
hotdog1134803hotdog
japing165013573japing
kapok10448783kap_ok
labor75117313la_bor
lacing94626233lacing
lad48165703la_d__
ladder84617623ladder
laddie83713173laddie
lade56345983la_d_e
laded74232613la_ded
laden65022193la_den
lader65633723la_der
lades65141273la_des
lading84227123lading
ladle66320443la_dle
ladron73413323ladron
lads56549133la_d_s
lady86527153la_d_y
laevo849363laevo_
lag47862123la___g
lagoon7410483lagoon
laid56439143laid__
laking115027043laking
laming94528363laming
lamping123116003lamping
lampion11278303lampion
lampoon11267193lampoon
land56337313land__
landau7310613landau
landed84619243landed
lander74028483lander
landing92819323landing
lands65426903land_s
lang56637383la__ng
lanugo735573lanugo
lap58565273lap___
lapel73716683lap_el
lapels83712043lapels
lapful1156483lapful
lapides103012043lapides
lapin75222923lap_in
lapins84520683lapins
lapis76223153lap_is
lapped114320033lapped
lapper104319953lapper
lappet103817723lappet
lapping124117023lapping
laps66848873lap__s
lapse74917683lap_se
lapsed94712583lapsed
lapser84113143lapser
lapses85217693lapses
lapsing103511163lapsing
lapsus8437273lapsus
laptops1166603laptops
lapwing13308263lapwing
lard56742003lard__
larded84319093larded
larder73720973larder
larding92917873larding
lardons83914493lardons
lardoon83410373lardoon
lards65331863lard_s
lardy96119273lard_y
largo65319783largo_
largos74815063largos
lasing74727983lasing
lasso55015683lasso_
lassos64913813lassos
latigo73410013latigo
laud56527723laud__
lauded83812153lauded
lauder73815013lauder
lauding93211903lauding
lauds65618483laud_s
laving104623573laving
lawing104625283lawing
laying104525703laying
lazing164821473lazing
leapfrog1441453leapfrog
leaping103215993leaping
lepton82510803lepton
lido56028153l_ido_
lidos65219883l_idos
log46252683l___og
loping93921413loping
papadom1466763papadom
pardon94618733pardon
prog75729003__prog
radon64620503ra_don
random92513553random
raping94829853raping
raptor83912823raptor
sandhog1275453sandhog
sapor75119253sap_or
sawlog1035793sawlog
seadog838743seadog
spado83713703spado_
sundog837613sundog
taping94222393taping
tardo65321103tardo_
tautog765713tautog
updo76712883_updo_
updos8389513_updos
vapor104013093vap_or
yapok14468153yap_ok
yapon104613583yap_on

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161444.86023192.6
3Display Results1441440.0463130.4
 (SQL Overall)1786911445.28233830.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.