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

48 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
hagbush164262(None) 
ambush1336112_ambush
habus106317142ha_bus_
hagbushes1842562hagbushes
hagbut1278912hagbu_t
hagbuts1354922hagbuts
hagfish17227612hagfish
haggish15207472haggish
highbush1642122highbush
maybush1742452maybush
shadbush1741972shadbush
tarbush1234172tarbush
abash106016513_a_bash
ablush1147223_ablush
abuse77119563_a_buse
aguish1059283_aguish
ankush13114433_ankush
babus95620333ba_bus_
bush96630713___bush
gush85424003__g_ush
habu97325483ha_bu__
hagborn1344953hagborn
haggis11209513haggis_
hags86740843hag__s_
haikus13538293haikus_
haimish1537753haimish
hairbrush1751803hairbrush
hakus125114113ha_kus_
hamburg1544123hamburg
harsh116418053ha__rsh
hash106936503ha___sh
hashish1238353hashish
haugh125114053ha__ugh
hawkish2036553hawkish
hogfish17257023hogfish
hoggish15247593hoggish
hogwash1742713hogwash
hush105224113h___ush
iambus10468903iambus_
kagus105812033kag_us_
magus85318753mag_us_
sagbut959753sagbu_t
sagbuts1065223sagbuts
sagebrush1551403sagebrush
saltbush1342133saltbush
tabus74820923ta_bus_
vagus96713813vag_us_
waggish15207073waggish

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 Limit134027487.73617325.1
3Display Results48480.0133692.3
 (SQL Overall)178691487.90522604.8
 
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.