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 “hipbones” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
hipbones154602(None) 
hipbone1445921hipbone_
chinbones1655032chinbones
hambones1539672hambones
hiplines13310592hiplines
histones11312802histones
pinbones1238142pinbones
shinbones1454582shinbones
ambones11312683_ambones
bilboes114410243bilbo_es
bimboes13498733bimbo_es
biplanes1238573biplanes
bizones1837823bi_zones
bones76446533___bones
chinbone1555163chinbone_
chinones13510483chi_nones
ciphonies1646543ciphonies
dapsones1138383dapsones
debones103315113_debones
depones103717093dep_ones
diaphones1547443diaphones
diploes101111493diplo_es
diplonts1146473diplonts
diploses111110323diploses
dipoles101013753dip_oles
eikones1137853ei_kones
epigones1138023epigones
fishbones1744263fishbones
gibbons1234983gibbon_s
gipons9389603gip_on_s
hambone1439313hambone_
hamboned1637003hamboned
haplonts1345773haplonts
haploses1338853haploses
haptenes133810823haptenes
hatboxes2055003hatboxes
henbanes1336583henbanes
heptanes1339003heptanes
heptoses1338373heptoses
hexones17299143h_exones
hidroses1237903hidroses
hilloes103815963hillo_es
hipline12311423hipline_
hipness12277383hip__ness
hippies142813753hip_pies
hippiness1635463hippiness
hippos13408433hippo__s
histone10312843histone_
hizzoner1942173hizzoner
hizzoners2041633hizzoners
hoboes114717453h_obo_es
hones88144493h___ones
hormones13311173hormones
hotboxes2045063hotboxes
hypnoses1646633hypnoses
hyponea1546453hyp_onea
hyponeas1646393hyp_oneas
icones84616383_i_cones
impones112712253_impones
intones7816543_intones
ionones7313883_ionones
irones64724013_i_rones
jawbones20134853jawbones
peones83821043__peones
peptones12311033peptones
phones114121213__phones
pinbone1138183pinbone_
pinones94717073pi_nones
pones74547043__p_ones
redbones1137593redbones
ribboned1343973ribboned
ribbons1136253ribbon_s
riboses9310443ri_boses
ringbones1244633ringbones
sawbones13126643sawbones
shinbone1354473shinbone_
shipborne1652843shipborne_
shippons15255663shippon_s
siphoned1446413siphoned
siphons1239353siphon_s
tailbones1155263tailbones
thighbones19153013thighbones
tiptoes939173tipto_es
umbones1138013_umbones
violones1137383violones
wishbones1743883wishbones

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 Filter1786911461620.436409841.7
2DLD Change Limit146162867.08020644.4
3Display Results86860.0302866.7
 (SQL Overall)178691867.54623680.2
 
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.