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

81 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
hipbone144592(None) 
hipbones1546021hipbones
chinbone1555162chinbone
hambone1439312hambone
hipline12311422hipline
histone10312842histone
pinbone1138172pinbone
shinbone1354462shinbone
shipborne1652832shipborne
airborne1044503airborne
biplane1139033biplane
bizone1738603bi_zone
bone65949323___bone
chinbones1655033chinbones
chinone12510153chi_none
ciphony1744973ciphony
dapsone1038463dapsone
debone93714783_debone
depone93616553dep_one
diaphone1447103diaphone
diploe9810153diplo_e
diplont10311693diplont
dipole91112853dip_ole
epigone1057843epigone
fishbone1644663fishbone
gibbon1135323gibbon_
gibbons1234973gibbons
gibbose1244083gibbose
gipon84212413gip_on_
gipons9389603gip_ons
hamboned1637003hamboned
hambones1539673hambones
haplont12412563haplont
haptene123810933haptene
henbane1237353henbane
heptane1238363heptane
heptose1237493heptose
hexone16289233h_exone
hiplike1637603hiplike
hiplines13310583hiplines
hippie132811243hip_pie
hipping153915103hipping
hippo12369063hippo__
hippos13408433hippo_s
hircine1239143hircine
histones11312803histones
hizzoner1942163hizzoner
hone77549323h___one
hormone12410503hormone
hyponea1546453hyp_onea
impone103011853_impone
intone61115423_intone
ionone6313443_ionone
irone55126363_i_rone
jawbone19134443jawbone
misdone10310863misdone
peptone11310763peptone
phone105621933__phone
pinbones1238133pinbones
pone65747533__p_one
prone75332623__prone
redbone1037973redbone
ribbon1036533ribbon_
ribboned1343973ribboned
ribbons1136243ribbons
ribbony1443543ribbony
ribose839893ri_bose
ringbone1144943ringbone
shinbones1454573shinbones
shippon14285803shippon_
shippons15255653shippons
siphon1138463siphon_
siphoned1446413siphoned
siphons1239343siphons
tailbone1045483tailbone
thighbone18122903thighbone
tiptoe838283tipto_e
upbore10247883_upbore
upborne11255133_upborne
violone1037153violone
wishbone1644293wishbone

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.1561145455.1
2DLD Change Limit134027816.92319359.7
3Display Results81810.0302700.0
 (SQL Overall)178691817.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.