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

113 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
henbanes133657(None) 
henbane1237351henbane_
heptanes1339002heptanes
herbages1437092herbages
hexanes17319462he_xanes
pentanes10316082pentanes
banes74945583___banes
benames112814603ben_ames
bennes86019013ben__nes
benzenes1946853benzenes
benzines1938213benzines
bugbanes1345153bugbanes
centares102913893centares
centones10313663centones
cetanes9315133ce_tanes
chinbones1655033chinbones
cowbanes1537423cowbanes
debases103814133de_bases
debates103718533de_bates
debones103315113de_bones
decanes103118913de_canes
dentines93418403dentines
deplanes11311213deplanes
dogbanes1245433dogbanes
embanks15295703_embanks
enables92813123_enables
enates64026433_en_ates
encages103313783_encages
encases93116053_encases
enfaces122110913_enfaces
engages92912493_engages
engines81114463_engines
enhances1339293_enhances
enlaces92313393_enlaces
enplanes1039483_enplanes
enrages83114853_enrages
entases72816273_entases
ethanes103713513_ethanes
fenlands1245183fenlands
fleabanes1443553fleabanes
hambones1539673hambones
handaxes1938403handaxes
hatbands1446293hatbands
headbands1644343headbands
heaves124120303he__aves
hebes105521673he_b__es
hectares1338853hectares
hektares1535813hektares
hemlines13310623hemlines
henbits12177003henb_its
henges104516463hen__ges
hennaed1135103henna_ed
hennas94211803hen__nas
henries102718283hen_ries
heptane1238363heptane_
herbage1337003herbage_
herbaged1554523herbaged
herbals122710603herba_ls
herniates1247333herniates
heroines112916573heroines
hetmans12187593hetman_s
hexades18378703he_xades
hexane16379533he_xane_
hexones17299143he_xones
hipbones1546023hipbones
hogmanes1446783hogmanes
honans94814503hon_an_s
husbands1444763husbands
inanes62519803_in_anes
kanbans1337723kanban_s
lindanes939173lindanes
membranes1545563membranes
menaces112715523men_aces
menages103615393men_ages
methanes133812163methanes
montanes101114523montanes
nonbanks1445033nonbanks
penances12312443pen_ances
penangs10268373pen_angs
penates93321603pen_ates
pendants1139093pendants
pennames12287793pennames
pennants1037063pennants
pennines103112043pennines
pentane9415743pentane_
pentenes10315633pentenes
phenates13611573phen_ates
pinbones1238143pinbones
rebates95123183re_bates
recanes93222263re_canes
redbones1137593redbones
renames92418053ren_ames
rennases848983rennases
rheobases1443203rheobases
senates73322613sen_ates
sensates8511143sensates
shebangs1443593she_bangs
shinbones1454583shinbones
tenaces92814513ten_aces
tenants7311013ten_ants
tendances1247573tendances
teniases838623teniases
tentages91011043tentages
terranes82514433terranes
thebaines1454963the_baines
thenages12107483then_ages
unbales92914863_unbales
unbans81912623_unban_s
vendaces1457183vendaces
venenes102712133ven_enes
venines103516613ven_ines
ventages12119773ventages
zenanas16286233zen_anas

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.423422437.4
2DLD Change Limit1461621136.93621073.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.40524131.1
 
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.