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

99 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
beehives164448(None) 
beehive1554031beehive_
beedies10314202beedi_es
beelines103312802beelines
beeves114615042bee__ves
behaves15198522b_ehaves
behoves15177352b_ehoves
beshiver1634482beshiver
beshivers1743712beshivers
alewives1444283alewives
archives16399553archives
beanies93821093beani_es
becrimes1467073becrimes
bedrivel1444083bedrivel
bedrivels1542713bedrivels
bedsides1246533bedsides
bedtimes1336593bedtimes
beebees1138013bee_bees
beeches143413883bee_ches
beechier1535633beechi_er
beechiest1645003beechi_est
beefier12329093beefi_er
beefiest13269013beefi_est
beefiness1435583beefiness
beelike13379783beelike_
beeline93314723beeline_
beelined11277713beelined
beerier93613023beeri_er
beeriest104013403beeri_est
beeriness1137863beeriness
beetles9312083bee_tles
begrimes1376513begrimes
beguiles1146103beguiles
beguines11127213beguines
behalves1644083behalves
behave14209013b_ehave_
behaved16176683b_ehaved
behaver15206723b_ehaver
behavers16205613b_ehavers
behinds1335283b_ehinds
behooves1653793behooves
behove14207203b_ehove_
behoved16205563b_ehoved
beiges91014403b_e_iges
belies84631053b_eli_es
believes13449403believes
belive115415303b_elive_
bellies94023723belli_es
bemires113212833b_emires
bemixes18338653b_emixes
benefices1645063benefices
bennies93917313benni_es
benzines1938213benzines
bereaves1338273bereaves
berhymes1843803berhymes
berimes115216643b_erimes
berlines102315453berlines
berries94423553berri_es
beshames1537203beshames
besides104814533b_esides
beslimes1246953beslimes
besmiles1237393besmiles
betaines10313293betaines
bethinks1765043bethinks
betides104915263b_etides
betimes115114413b_etimes
betises94816123b_etises
bevies114017303b_evi_es
boehmites1663023boehmites
bothies12414783bothi_es
breves115516423bre__ves
brewises1337213brewises
chives144317593__chives
deceives1437903deceives
deprives1438393deprives
derives114017813_derives
endives113710693_endives
hives116925513___hives
keeves133711983kee__ves
khedives1942183khedives
peeries93623023peeri_es
peeves113814873pee__ves
prelives13310383prelives
receives1339743receives
redrives122610393redrives
reeves94721493ree__ves
regives115014213_regives
rehires105016113_rehires
reives95723043_re_ives
relives104619443_relives
reshaves1438733reshaves
reshines112615443reshines
revives134715543_revives
shives124921413__shives
techies12513603techi_es
veeries102916893veeri_es
weenies102915093weeni_es
weepies122811743weepi_es
yeshivas1742063yeshivas

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.1561145455.1
2DLD Change Limit146162997.62619166.3
3Display Results99990.0462152.2
 (SQL Overall)178691997.82822827.2
 
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.