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

202 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
pinhole12201043(None) 
piehole12188551piehole
pinholes131810661pinholes
pinole83218781pin_ole
airhole1048272airhole
cineole91010002cineole
indole74516052_indole
inhale9411512_inhale
insole63515862_insole
manhole12311342manhole
oilhole1046262oilhole
pieholes13168912pieholes
pinbone1138182pinbone
pinfold1336232pinfold
pinnule936002pinnule
pinocle1138142pinocle
pinoles93418702pin_oles
pintle83818262pin_tle
pinwale1257842pinwale
pishoge1336692pishoge
pistole92414312pistole
pothole12312172pothole
sinkhole1594382sinkhole
airholes1138033airholes
anisole71010833anisole
anole55330383_an_ole
armhole1236943armhole
asshole1046793asshole
benzole1837133benzole
bindle94516263bin_dle
binocle1136493binocle
bunghole1444183bunghole
cineol8108203cineol_
cineoles10109403cineoles
cineols9128853cineols
citole8311503ci_tole
condole102914953condole
console92715983console
dhole95215363__dhole
diazole1736793diazole
dindle84417223din_dle
dingle84317073din_gle
dipole91112853di_pole
eyehole1346003eyehole
finable122213623finable
finagle11238313finagle
finale94116763fin_ale
fishpole1644053fishpole
foxhole2045073foxhole
gunkhole1693253gunkhole
hole77553393___hole
income10712093_income
indol63714873_indol_
indoles83716363_indoles
indols74714203_indols
infold10128163_infold
ingle64120433_in_gle
inhaled1169333_inhaled
inhaler1068053_inhaler
inhales10511863_inhales
inhere9313713_inhere
inholder1276113_inholder
inhume1196583_inhume
inkle94515833_in_kle
inshore1038723_inshore
insoles73516243_insoles
intone61115433_intone
invoke1336213_invoke
involve1345093_involve
inwove12167273_inwove
jingle143815223jin_gle
keyhole1764433keyhole
kindle114414233kin_dle
kinfolk1363603kinfolk
linable92214343linable
lintol6369473lintol_
lintols7339553lintols
manholes13311183manholes
midsole1037813midsole
minable112315073minable
mingle93518783min_gle
mudhole1344913mudhole
nonhome1248833nonhome
oilholes1146153oilholes
pandore10411853pandore
panicle11129983panicle
pantile93918483pantile
pantofle1364553pantofle
parole84425253p_arole
peephole1545983peephole
penholder1544413penholder
penile82219603pen_ile
pensile92713543pensile
pentode1039893pentode
pentose9311593pentose
pesthole1347553pesthole
petiole9311303petiole
phone105621933p__hone
phyle134111153p__hyle
piccolo1354403piccolo
picholine1646643picholine
pickle144215653pi_ckle
picomole1445723picomole
piddle103514913pi_ddle
piffle14418233pi_ffle
pigeonhole16132153pigeonhole
pignoli1045443pignoli
pile65649693pi___le
pilose84514243pi_lose
pilule8411123pi_lule
pimple123512963pi_mple
pinafore1344513pinafore
pinball1137933pinball
pinbones1238143pinbones
pine67755713pin___e
pineal84817683pineal_
pineals93212843pineals
pinecone1246063pinecone
pinene82915643pin_ene
pinfolded1643333pinfolded
pinfolds1445143pinfolds
pingo87122713pingo__
pingoes105116523pingoes
pingos95317673pingo_s
pinhead13347073pinhead
pinion83815893pinio_n
pinioned1137513pinioned
pinions93413603pinions
pinite8321243pin_ite
pinitol936683pinitol_
pinitols1046103pinitols
pinkeye16326493pinkeye
pinkie124414273pin_kie
pinkly155012243pin_kly
pinko115618253pinko__
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinnace113510313pinnace
pinnacle12416963pinnacle
pinnae84414643pin_nae
pinnal84814273pinnal_
pinnate93613743pinnate
pinnula934913pinnula
pinnulae1044183pinnulae
pinnules1036463pinnules
pinochle1544743pinochle
pinocles1248693pinocles
pinon76024533pin_o_n
pinones94717073pin_ones
pinons86019943pin_ons
pinot78737293pin_o_t
pinots85920273pin_ots
pintles94118723pin_tles
pinto75625753pinto__
pintoes95117713pintoes
pintos86021293pinto_s
pinwales1367963pinwales
pinwheel1642523pinwheel
pinwork16107243pinwork
pinworm1467183pinworm
pinyon11459763pinyo_n
pinyons12299003pinyons
piolet83225643pi__olet
pishoges1446953pishoges
pishogue1442833pishogue
pistol83313333pistol_
pistoled11259593pistoled
pistoles102514723pistoles
pistols93213983pistols
pitchpole1843353pitchpole
pithily1567033pithily
pizzle16279493pi_zzle
plimsole1243663plimsole
pole65951303p___ole
porthole1349523porthole
posole8314223p_osole
posthole1339533posthole
potholed1448393potholed
potholes13312933potholes
pozole1758913p_ozole
prole74527793p__role
pungle94413573pun_gle
pyrrole1246033pyrrole
rathole10312053rathole
rissole739783rissole
single74520603sin_gle
sinkholes1684323sinkholes
spindle103210093spin_dle
spinelle1046223spinelle
spinose937943spin_ose
spinule9299993spin_ule
taphole1239773taphole
thole85620843__thole
tingle74319063tin_gle
tinhorn1046033tinhorn
tinkle103714453tin_kle
unholy1238163_unholy
whole114418093__whole
windle104617953win_dle
winkle133812833win_kle
winsome1237463winsome
wintle94014603win_tle

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.406440125.6
2DLD Change Limit1340272027.20318607.1
3Display Results2022020.0633206.3
 (SQL Overall)1786912027.67223291.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.