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

187 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
pinholes13181066(None) 
pieholes13168911pieholes
pinhole122010431pinhole_
pinoles93418711pin_oles
airholes1138032airholes
cineoles10109402cineoles
indoles83716362_indoles
inhales10511862_inhales
insoles73516242_insoles
manholes13311182manholes
oilholes1146152oilholes
piehole12188552piehole_
pinbones1238142pinbones
pinfolds1445142pinfolds
pingoes105116522pingo_es
pinkoes135512312pinko_es
pinnules1036472pinnules
pinocles1248692pinocles
pinole83218782pin_ole_
pinones94717072pin_ones
pintles94118732pin_tles
pintoes95117712pinto_es
pinwales1367962pinwales
pishoges1446952pishoges
pistoles102514722pistoles
potholes13312932potholes
sinkholes1684322sinkholes
airhole1048273airhole_
anisoles81010123anisoles
anoles64827433_an_oles
armholes1347383armholes
assholes1146743assholes
benzoles1936993benzoles
bindles104016453bin_dles
bingoes104013983bingo_es
binocles1236413binocles
bungholes1543993bungholes
cineole91010003cineole_
cineols9128853cineol_s
citoles9312553ci_toles
condoles113015803condoles
consoles103216153consoles
dholes104914793__dholes
diazoles1836323diazoles
dindles93817243din_dles
dingles93818323din_gles
dingoes94114833dingo_es
dipoles101013753di_poles
eyeholes1445593eyeholes
finagles12237553finagles
finales104016013fin_ales
fishpoles1743633fishpoles
foxholes2144693foxholes
ginzoes1735433ginzo_es
gunkholes17103153gunkholes
holes84748653___holes
incomes11712373_incomes
indole74516053_indole_
indols74714203_indol_s
infolds11137023_infolds
ingles74420873_in_gles
inhale9411523_inhale_
inhaled1169333_inhaled
inhaler1068053_inhaler
inhalers1166643_inhalers
inheres10315173_inheres
inholder1276113_inholder
inholders1345353_inholders
inhumes1296883_inhumes
inkles103515653_in_kles
insole63515863_insole_
intones7816553_intones
invokes1436383_invokes
involves1444973_involves
jingles153816383jin_gles
jingoes153811443jingo_es
keyholes1844593keyholes
kindles123614843kin_dles
kinfolks1453013kinfolks
lingoes84014693lingo_es
lintols7339553lintol_s
manhole12311343manhole_
midsoles1137763midsoles
mingles103719003min_gles
mudholes1444873mudholes
oilhole1046263oilhole_
pandores11312453pandores
panicles121010133panicles
pantiles103617163pantiles
pantofles1474873pantofles
paroles95025893p_aroles
pathoses13412773pathoses
peepholes1646283peepholes
penholder1544413penholder
penholders1643793penholders
pentodes11310363pentodes
pentoses10312893pentoses
pestholes1448233pestholes
petioles10311643petioles
phones114121213p__hones
piccolos1444133piccolos
picholines1746303picholines
pickles153215443pi_ckles
picomoles1545913picomoles
piddles114314273pi_ddles
piffles15368773pi_ffles
pigeonholes17132243pigeonholes
pignolis1146053pignolis
piles74742613pi___les
pilules9510623pi_lules
pimples133012423pi_mples
pinafores1444503pinafores
pinballs1246933pinballs
pinbone1138183pinbone_
pinches144117943pin_ches
pineals93212853pineal_s
pinecones1346253pinecones
pinenes93416693pin_enes
pineries102419083pineries
pines76048863pin___es
pinfold1336233pinfol_d
pinfolded1643333pinfolded
pingos95317673pingo__s
pinheads14336243pinheads
pinioned1137523pinioned
pinions93413603pinio_ns
pinites9319533pin_ites
pinitols1046113pinitol_s
pinkeyes17335973pinkeyes
pinkies133818263pin_kies
pinkos125313873pinko__s
pinnaces12268863pinnaces
pinnacles13276043pinnacles
pinnies93318443pin_nies
pinnule936003pinnule_
pinochles1644863pinochles
pinocle1138143pinocle_
pinons86019943pin_o_ns
pinots85920273pin_o_ts
pintle83818263pin_tle_
pintos86021293pinto__s
pinwale1257843pinwale_
pinwheels1742313pinwheels
pinworks17106353pinworks
pinworms15115783pinworms
pinyons12299003pinyo_ns
piolet83225643pi__olet
piolets93513193pi__olets
pishes114722103pish__es
pishoge1336693pishoge_
pishogues1543003pishogues
pistole92414313pistole_
pistoled11259593pistoled
pistols93213983pistol_s
pitchpoles1953243pitchpoles
pithless13117023pith_less
pizzles17329273pi_zzles
plimsoles1343573plimsoles
poles75351003p___oles
portholes14410373portholes
posoles9314883p_osoles
postholes14410453postholes
pothole12312173pothole_
potholed1448393potholed
pozoles1839063p_ozoles
princoxes2044103princoxes
proles84627203p__roles
pungles104013713pun_gles
pyrroles1345453pyrroles
ratholes11312413ratholes
rissoles839113rissoles
senhores112810993senhores
singles83520433sin_gles
sinkhole1594383sinkhole_
spindles112710353spin_dles
spinelles1146083spinelles
spinules10249333spin_ules
tapholes1339623tapholes
tholes94919783__tholes
tingles83818323tin_gles
tinhorns1145013tinhorns
tinkles113713923tin_kles
wholes124616773__wholes
windles113518493win_dles
winkles143412773win_kles
winoes94317013win_o_es
wintles103414983win_tles

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.420425454.8
2DLD Change Limit1461621877.61019206.6
3Display Results1871870.0802337.5
 (SQL Overall)1786911878.11022033.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.