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

119 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
tapholes133962(None) 
taphole1239771taphole_
manholes13311182manholes
ratholes11312412ratholes
tadpoles1135952tadpoles
taphouse1346332taphouse
taphouses1446552taphouses
tholes94919782t__holes
aholds10469483_a_holds
airholes1138033airholes
amoles84122193_a_moles
anoles64827433_a_noles
apheses12610703_apheses
aphides134711203_aphides
apholates1449683_apholates
apples104315763_ap_ples
apposes11511473_apposes
areoles71016953_areoles
armholes1347383armholes
assholes1146743assholes
azoles154614613_a_zoles
bathoses13310463bathoses
cajoles163712103ca_joles
camphols1746243camphol_s
capotes11314643cap_otes
caprioles1376753caprioles
capsules1236623capsules
carioles10817073carioles
cathodes1439393cathodes
coalholes1445373coalholes
daphnes13327683daph_nes
dapples1238993dap_ples
dapsones1138383dapsones
darioles9710693darioles
dholes104914793__dholes
diaphones1547443diaphones
dipoles101013753dip_oles
earphones1448393earphones
eyeholes1445593eyeholes
foxholes2144693foxholes
haoles94919803ha__oles
haploses1338853haploses
holes84748653___holes
kathodes1646183kathodes
keyholes1844593keyholes
kyphoses2045283kyphoses
loopholes1448893loopholes
mahoes11313103ma_ho_es
manhole12311343manhole_
maples104819423map__les
maypoles1545993maypoles
mudholes1444873mudholes
naphtols13143693naphtol_s
oilholes1146153oilholes
papooses1248053papooses
papules112411573pap_ules
paroles95025883pa_roles
pathoses13412773pathoses
peepholes1646283peepholes
phones114121213__phones
pieholes13168913pieholes
pinholes131810663pinholes
poles75351003__p_oles
potholes13312933potholes
proles84627203__proles
rampoles1238893rampoles
raphes115117453raph__es
raphides14188393raphides
rathole10312053rathole_
safroles1136933safroles
sapotes9313943sap_otes
saprobes1237033saprobes
stanhopes1444453stanhopes
staples93617213stap__les
tables84524893ta__bles
tabooley1342993tabooley
tabooleys1441733tabooleys
taches114224173tach__es
tackles133816523ta_ckles
tacnodes1145003tacnodes
tadpole1036143tadpole_
tailles72516473ta_illes
tales55451373ta___les
tallols73311363tallol_s
tamales93216153ta_males
tangles83920043ta_ngles
tapalos938813tap_alos
tapeless10218643tap_eless
tapes75838603tap___es
tapiocas1244783tapiocas
tapises92914013tap_ises
taprooms1246663taprooms
taproots1047253taproots
tattles73616283ta_ttles
taxables1734383taxables
taxols13328633ta_xol_s
thole85620843t__hole_
tholed105113873t__holed
tholos94213003t__holos
tipples112811253tip_ples
tiptoes939173tipto_es
toeholds1245093toeholds
toles55147133t___oles
toluoles835513toluoles
tophes115218423toph__es
topples113111653top_ples
tracheoles1545623tracheoles
trachles13311753trach_les
typhoids1745493typhoids
typhons1537083typho_ns
typhoons1644563typhoons
typhose1546693typhose_
typhous1566323typho_us
typhuses1643763typhuses
upholds13135243_upholds
vacuoles1345013vacuoles
varioles11711123varioles
wholes124616773__wholes
zeppoles2143583zeppoles

Search took 9 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 Filter1786911461620.186960704.3
2DLD Change Limit1461621197.79618748.3
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.02822258.5
 
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.