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

103 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
lapdogs113407(None) 
lapdog1034441lapdog_
bandogs1138362bandogs
laptops1166602laptops
lardons83914492lardons
ados57633513_a_do_s
aldols7109713_aldols
apodous1037393_apodous
apods86316343_ap_ods
apologs1038593_apologs
apos65433823_ap_o_s
aprons8316993_aprons
ardors74416863_ardors
bandog1038723bandog_
candors104216763candors
cantdogs1244043cantdogs
capons104119503cap_ons
capos94826073cap_o_s
captors113914983captors
cardons104519933cardons
coydogs1434493coydogs
dadoes85616533da_does
dados75522433da_do_s
dogs66440153___dogs
fados95620733fa_do_s
fandoms13229473fandoms
fogdogs1333263fogdogs
gundogs1034603gundogs
hagdons1258523hagdons
hangdogs1443603hangdogs
hotdogs1234453hotdogs
kapoks11347263kap_oks
labors84016403la_bors
lacings105013653lacings
ladders94115173ladders
laddies93715053laddies
ladens74516233la_dens
laders74927763la_ders
lades65141273la_d_es
ladies75124883la_dies
ladings93814133ladings
ladles74619543la_dles
ladrons83813193ladrons
lads56549133la_d__s
lagoons839253lagoons
lags56546223la___gs
lakings124713503lakings
lampions12277973lampions
lampoons12266863lampoons
landaus8310343landaus
landers84026213landers
landings103110073landings
lands65426903land__s
lanugos834453lanugos
lapels83712043lap_els
lapfuls1234503lapfuls
lapides103012043lapides
lapins84520683lap_ins
lapis76223153lap__is
lapises93513463lapises
lappers113717463lappers
lappets11329123lappets
laps66848873lap___s
lapsers93911053lapsers
lapses85217693lap_ses
lapsus8437273lap_sus
laptop1076813lapto_p
lapwings14274973lapwings
larders83516943larders
lardon74415063lardo_n
lardoon83410373lardoon
lardoons9398483lardoons
lards65331863lard__s
largos74815063largo_s
lassoes74613853lassoes
lassos64913813lasso_s
latigos8277243latigos
lauders84012893lauders
lauds65618483laud__s
lawings113611473lawings
leapfrogs1551713leapfrogs
leprous938843leprous
leptons91910413leptons
lidos65219883l_ido_s
logs57343113l___ogs
lupous849433lup_ous
papadoms1575923papadoms
pappous1057463pappous
pardons103817623pardons
progs86624153__progs
radons74118523ra_dons
randoms102112433randoms
raptors94213353raptors
sandhogs1365483sandhogs
sapors84118813sap_ors
sawlogs1135393sawlogs
seadogs958643seadogs
sundogs947103sundogs
tautogs875413tautogs
updos8389513_updo_s
vapors113812693vap_ors
yapoks15346783yap_oks
yapons114411773yap_ons

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271037.54617761.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.73223110.6
 
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.