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

117 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
tadpole103614(None) 
tadpoles1135951tadpoles
maypole1446382maypole
rampole1139692rampole
taphole1239772taphole
addle74318353_ad_dle
adipose1036653_adipose
adobe84814713_ad_obe
adore65723673_ad_ore
adoze155713833_ad_oze
amole75724593_a_mole
ample94720303_amp_le
ampoule11116603_ampoule
ampule10710613_ampule
anole55330383_a_nole
apple94517673_a_pple
appose10411993_appose
areole61017283_areole
azole145118033_a_zole
beanpole1244333beanpole
cadelle1039923cadelle
cajole154011183ca_jole
capote10315733ca_pote
cariole9818343cariole
carpale113414353carpale
clodpole1343603clodpole
daddle94214283dad_dle
dapple1138853da_pple
dariole8711163dariole
dhole95215363__dhole
dipole91112853_dipole
dole56550003__d_ole
fadable13310463fadable
flagpole1443583flagpole
haole84820083ha__ole
indole74516053ind_ole
ladle66320443lad__le
ladrone83611873ladrone
madrone102812663madrone
manhole12311343manhole
maple95521143ma_p_le
maypoles1545993maypoles
midsole1037813midsole
mudhole1344913mudhole
paddle104615143pad_dle
padle84522343pad__le
padrone102512073padrone
pappose1047413pappose
papule102212133pa_pule
parole84425253pa_role
pole65951303___pole
raddle84816173rad_dle
radiale83813523radiale
radicle103510713radicle
radome9511873rad_ome
rampoles1238893rampoles
rathole10312053rathole
redpoll1045043redpoll
saddle83915493sad_dle
safrole1037253safrole
sample104215013samp_le
sandpile1146773sandpile
sapote8314363sa_pote
staddle9288093stad_dle
staple84415823sta_p_le
table75429603ta__ble
tabooley1342993tabooley
tackle123815733ta_ckle
tacnode1045093tacnode
tactile9310613tactile
taille63116923ta_ille
takable13310193takable
talcose938133talcose
tale46154163ta___le
tallol63612223tallol_
tallols73311363tallols
tamable11312853tamable
tamale83717403ta_male
tampala1136613tampala
tampon102911233tampo_n
tamponed1336023tamponed
tampons112711563tampons
tangle74019953ta_ngle
tapalo839793ta_palo
tape64538143ta_p__e
tapholes1339623tapholes
tappable1436343tappable
tarpon82812803tarpo_n
tarpons92612213tarpons
tattle64115653ta_ttle
taupe7314163taup__e
tawpie11339143tawp_ie
taxable1639073taxable
taxol124011363ta_xol_
taxols13328633ta_xols
temple102811333temp_le
thole85620843t__hole
tipple103411913t_ipple
toddle85811033tod_dle
tole46052903t___ole
toluole736113toluole
topple104411323t_opple
tradable1139873tradable
trample11299703tramp_le
trappose1245813trappose
triple84215923trip_le
tripoli937133tripoli
twaddle12245713twad_dle
vacuole1245373vacuole
vadose1037963vad_ose
variole10711593variole
wadable13310233wadable
waddle114715303wad_dle
wadmol1234053wadmol_
wadmoll1352903wadmoll
wadmols1333913wadmols
zeppole2043493zeppole

Search took 7 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.406440125.6
2DLD Change Limit1340271176.20321606.8
3Display Results1171170.0303900.0
 (SQL Overall)1786911176.63926915.3
 
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.