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

156 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
pinbones123814(None) 
pinbone1138181pinbone_
pinones94717071pin_ones
chinbones1655032chinbones
hipbones1546022hipbones
intones7816542_intones
pinecones1346252pinecones
pinenes93416692pin_enes
pingoes105116522pingo_es
pinholes131810662pinholes
pinioned1137512pinioned
pinions93413602pinion_s
pinkoes135512312pinko_es
pinoles93418712pin_oles
pinons86019942pin_on_s
pintoes95117712pinto_es
pinyons12299002pinyon_s
ringbones1244632ringbones
shinbones1454582shinbones
ambones11312683_ambones
ancones93116343_ancones
bilboes114410243bilbo_es
bimboes13498733bimbo_es
bingoes104013983bingo_es
bizones1837823bi_zones
bonbons1139333bonbon_s
bones76446533___bones
canzones1939153canzones
centones10313663centones
chinbone1555163chinbone_
chinones13510483chin_ones
cineoles10109403cineoles
condones112817393condones
debones103315113_debones
dingoes94114833dingo_es
eikones1137853ei_kones
epigones1138023epi_gones
fishbones1744263fishbones
gibbons1234983gibbon_s
ginzoes1735433ginzo_es
hambones1539673hambones
henbanes1336583henbanes
hipbone1445923hipbone_
histones11312803histones
icones84616383_i_cones
impones112712253_impones
inanes62519803_in_anes
inbounds11134053_inbounds
incomes11712373_incomes
indenes82916253_indenes
indoles83716363_indoles
inions64417003_inion_s
insoles73516243_insoles
intines7921113_intines
intone61115433_intone_
intoned8811993_intoned
intoner7811673_intoner
intoners889933_intoners
invokes1436383_invokes
ionones7313883_ionones
irones64724013_i_rones
jawbones20134853jawbones
jingoes153811443jingo_es
lindanes939173lindanes
lingoes84014693lingo_es
minions93314623minion_s
ninons64913773nin_on_s
nones55639133__n_ones
opinioned1243273opinioned
opinions1045933opinion_s
padrones112711043padrones
pandores11312453pandores
pangenes112612833pangenes
pannes85522853pan__nes
pegboxes2043143pegboxes
pennines103112043pennines
pennoned1136313pennoned
pennons939713pennon_s
pensiones11410003pensiones
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
peones83821043p__eones
peptones12311033peptones
perniones1148593perniones
phones114121213p__hones
pieholes13168913pieholes
pigboats1344523pigboats
pigeons1039183pigeon_s
pillboxes2053353pillboxes
pinafores1444503pinafores
pinangs10267793pin_angs
pinballs1246933pinballs
pinches144117943pin_ches
pinecone1246063pinecone_
pinene82915653pin_ene_
pineries102419083pineries
pines76048863pi___nes
pinfolds1445143pinfolds
pingos95317673pingo__s
pinhole122010433pinhole_
pinion83815893pinion__
pinites9319533pin_ites
pinkened1535753pinkened
pinkens13419653pinken_s
pinkeyes17335973pinkeyes
pinkies133818263pin_kies
pinkings15338143pinkings
pinkness1436513pin_kness
pinkos125313873pinko__s
pinnaces12268863pinnaces
pinnas85315523pin__nas
pinned94818383pin__ned
pinner84521503pin__ner
pinners93518603pin__ners
pinnies93318443pin_nies
pinnules1036473pinnules
pinocles1248693pinocles
pinole83218783pin_ole_
pinon76024533pin_on__
pinots85920273pin_o_ts
pinpoints1344153pinpoints
pintanos10107553pintanos
pintles94118733pin_tles
pintos86021293pinto__s
pinwales1367963pinwales
pinworks17106353pinworks
pinworms15115783pinworms
pinyon11459763pinyon__
pions75826393pi__on_s
pishoges1446953pishoges
pistoles102514723pistoles
pistons93016373piston_s
pitons85319043pi_ton_s
pones74547043p___ones
pontons93315553ponton_s
princoxes2044103princoxes
propones122516963propones
pyrones123113303p_yrones
quinones17227753quin_ones
redbones1137593redbones
ribboned1343973ribboned
ribbons1136253ribbon_s
riboses9310443ri_boses
ringbone1144953ringbone_
sawbones13126643sawbones
shinbone1354473shinbone_
tailbones1155263tailbones
tinstones948493tinstones
umbones1138013_umbones
unboned103014223_unboned
unboxes16208303_unboxes
violones1137383violones
winoes94317013win_o_es
wishbones1743883wishbones

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 Limit1461621567.84618628.9
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.32921454.1
 
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.