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

174 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
pothole1231217(None) 
porthole1349521porthole
posthole1339531posthole
potholed1448391potholed
potholes13312931potholes
bolthole1345462bolthole
foxhole2045072foxhole
knothole1544072knothole
pesthole1347552pesthole
petiole9311302petiole
piehole12188552piehole
pinhole122010432pinhole
portholes14410372portholes
posole8314222po_sole
postholes14410452postholes
potable112115362potable
potholder1544762potholder
pothook1656882pothook
pothos114214692potho_s
pothouse1348702pothouse
pottle84416102pot_tle
pozole1758912po_zole
rathole10312052rathole
shothole1445512shothole
thole85620842__thole
airhole1048273airhole
anethole1146253anethole
apothece1543773apothece
armhole1236943armhole
asshole1046793asshole
blowhole1644593blowhole
boltholes1445723boltholes
borehole1347623borehole
bottle84916073bot_tle
cathode1338993cathode
citole8311503cit_ole
coalhole1345093coalhole
condole102914953condole
console92715983console
dhole95215363__dhole
dottle74212503dot_tle
eyehole1346003eyehole
foothold1545203foothold
foveole13106873foveole
foxholes2144693foxholes
gothite1146403gothite
hole77553393___hole
hothouse1447353hothouse
kathode1545733kathode
keyhole1764433keyhole
knotholes1644173knotholes
loophole1358633loophole
lothsome1345013lothsome
manhole12311343manhole
motile83818343mot_ile
mottle84116053mot_tle
mudhole1344913mudhole
nonhome1248833nonhome
notable92114903notable
obole75917143_o_bole
ochone11311293_ochone
oilhole1046263oilhole
oriole6814293_oriole
osmole8128513_osmole
ostiole739013ostiole
otiose639403_otiose
outsole71013433outsole
parole84425253p_arole
pathogen1446463pathogen
pathos115516693patho_s
pathoses13412773pathoses
patrol83213023patrol_
patrols93513513patrols
peephole1545983peephole
pestholes1448233pestholes
petioled1137993petioled
petioles10311643petioles
petrale9312623petrale
petrol82714063petrol_
petrols92913083petrols
pettle84116053pet_tle
phone105621933p__hone
phyle134111153p__hyle
pieholes13168913pieholes
pinholes131810663pinholes
pinole83218783p_inole
pishoge1336693pishoge
pistole92414313pistole
pitchpole1843353pitchpole
pithily1567033pithily
podsol946853podsol_
podsols1056513podsols
podzol1835083podzol_
podzols1934683podzols
poechore1547853poechore
pokable15209503pokable
pole65951303p___ole
polyol1138713polyol_
polyols1238493polyols
poodle93112043po_odle
pool65835953po__ol_
pooled94619813po__oled
pooler83819843po__oler
pools74427703po__ols
poove104514303po__ove
popple92710983po_pple
porose84818743po_rose
portable12313203portable
posable112212783posable
poshly1437723posh_ly
posoles9314883po_soles
postcode1346323postcode
postpone1248693postpone
postpose1247653postpose
potables12179703potables
potage92715903pot_age
potboil1195463potboil
potboiled1443273potboiled
potboiler1352843potboiler
potboils1284633potboils
potboy1397813potbo_y
potboys1475273potboys
potence11711363potence
potful1138083potful_
potfuls1236293potfuls
pothead133810393pothead
potheen12257893potheen
pother113818853poth_er
potherb14358683potherb
pothered142311043pothered
pothers123818623pothers
potholders1644343potholders
pothooks1746053pothooks
pothouses1449043pothouses
potiche1438043potiche
potion84519573potio_n
potions93417423potions
potlike13910123potlike
potline91015233potline
potpie103412433pot_pie
potshot1249733potsho_t
potshots1346283potshots
potsie83916033pot_sie
potstone1039423potstone
pottage103310603pottage
pottles93816983pot_tles
potto75320943potto__
pottos84615873potto_s
pozoles1839063po_zoles
prole74527793p__role
proteome12228423proteome
proteose10229413proteose
protyle12229453prot_yle
pyrrole1246033pyrrole
python1447143pytho_n
pythons1537363pythons
ratholes11312413ratholes
roothold1244763roothold
shotholes1546183shotholes
sotol54917653sot_ol_
sotols63714473sot_ols
spathose1345633spathose
stole54928813_st_ole
taphole1239773taphole
tholed105113873__tholed
tholes94919783__tholes
those85218143__those
toehold1146573toehold
tole46052903__t_ole
toluole736113toluole
totable92313363totable
votable122111373votable
whole114418093__whole
wormhole1644663wormhole

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 Limit1340271746.01622278.4
3Display Results1741740.0602900.0
 (SQL Overall)1786911746.48227567.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.