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

130 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
taphole123977(None) 
tapholes1339621tapholes
manhole12311342manhole
rathole10312052rathole
tadpole1036142tadpole
taphouse1346332taphouse
thole85620842t__hole
typhose1546692typhose
ahold94714253_a_hold
airhole1048273airhole
amole75724593_a_mole
anole55330383_a_nole
apholate13410473_apholate
apple94517673_ap_ple
appose10411993_appose
areole61017283_areole
armhole1236943armhole
ashore9414613_ashore
asshole1046793asshole
awhile1257793_awhile
azole145118033_a_zole
cajole154011183ca_jole
camphol1645793camphol_
camphols1746243camphols
capable13313363capable
capote10315733cap_ote
capriole1276913capriole
capsule1137343capsule
cariole9818343cariole
cathode1338993cathode
coalhole1345093coalhole
daphne12237013daph_ne
dapple1138853dap_ple
dapsone1038463dapsone
dariole8711163dariole
dhole95215363__dhole
diaphone1447103diaphone
dipole91112853dip_ole
earphone1348253earphone
eyehole1346003eyehole
foxhole2045073foxhole
haole84820083ha__ole
hole77553393___hole
kathode1545733kathode
keyhole1764433keyhole
loophole1358633loophole
mahoe10315573ma_ho_e
manholes13311183manholes
maple95521143map__le
maypole1446383maypole
mudhole1344913mudhole
naphtol12124023naphtol_
naphtols13143693naphtols
oilhole1046263oilhole
papoose1147513papoose
pappose1047413pappose
papule102212133pap_ule
parole84425253pa_role
peephole1545983peephole
phone105621933__phone
phyle134111153__phyle
piehole12188553piehole
pinhole122010433pinhole
pole65951303__p_ole
pothole12312173pothole
prole74527793__prole
rampole1139693rampole
raphae114311733raph_ae
raphe104916423raph__e
raphide13138073raphide
ratholes11312413ratholes
safrole1037253safrole
sapote8314363sap_ote
saprobe1137333saprobe
stanhope1344273stanhope
staple84415823stap__le
table75429603ta__ble
tabooley1342993tabooley
tache106222373tach__e
tackle123815733ta_ckle
tacnode1045093tacnode
tactile9310613tactile
tadpoles1135953tadpoles
taille63116923ta_ille
takable13310193takable
talcose938133talcose
tale46154163ta___le
tallol63612223tallol_
tallols73311363tallols
tamable11312853tamable
tamale83717403ta_male
tangle74019953ta_ngle
tapalo839793tap_alo
tapalos938813tapalos
tape64538143tap___e
tapeable1238823tapeable
taphouses1446553taphouses
tapioca1144633tapioca
tappable1436343tappable
taproom1147963taproom
taproot9412673taproot
tattle64115653ta_ttle
taxable1639073taxable
taxol124011363ta_xol_
taxols13328633ta_xols
tholed105113873t__holed
tholes94919783t__holes
those85218143t__hose
tipple103411913tip_ple
tiptoe838283tipto_e
toehold1146573toehold
tole46052903t___ole
toluole736113toluole
tophe106718973toph__e
topple104411323top_ple
tracheole1445573tracheole
trachle12311853trach_le
trappose1245813trappose
typable1435883typable
typhoid1648133typhoid
typhon1436673typho_n
typhons1537083typhons
typhoon1544653typhoon
typhous1566323typhous
uphold12126903_uphold
uphove1436133_uphove
vacuole1245373vacuole
variole10711593variole
whole114418093__whole
zeppole2043493zeppole

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.826216332.9
2DLD Change Limit1340271306.75319847.0
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.62523434.9
 
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.