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

71 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
hubbub124360(None) 
hubbubs1342601hubbubs
hubbly16478412hubbly
hubby155011392hubb_y
humbug1434802humbug
blub85324873__blub
bub76343973___bub
bubba84311793bubb_a
bubbas94110703bubbas
bubble94016593bubble
bubbly124110353bubbly
bubby115013923bubb_y
bubu85022663bu_bu_
bubus95115453bu_bus
bulbul10348073bulbul
chubby1844123chubb_y
cubby145212113cubb_y
cubeb115814653cu_beb
dibbuk1543503dibbuk
dubbed124113213dubbed
dubber113814553dubber
dubbin11329253dubbin
dybbuk1841753dybbuk
flubdub1541703flubdub
fubbed144711243fubbed
haboob1377883haboob
habu97325483h_abu_
habus106317143h_abus
hagbut1278913hagbut
hobbed144114303hobbed
hobber134114633hobber
hobbit132810523hobbit
hobble133913433hobble
hobby155913723hobb_y
hobnob1335133hobnob
hub86437483h___ub
hubbies143211563hubbies
hubcap1553993hubcap
hubris11218973hubris
hubs96027143hu_b_s
humble133615053humble
humbly164010523humbly
humbugs1534243humbugs
hummus1336243hummus
humour11116753humour
humus106215073hu_mus
jubbah2034353jubbah
lubber104214623lubber
mudbug1243253mudbug
nubbin10308283nubbin
nubble103813713nubble
nubbly13369673nubbly
nubby125011023nubb_y
outbuy1146943outbuy
rhubarb1442163rhubarb
rubbed114515083rubbed
rubber104715793rubber
rubble104315673rubble
rubbly133710613rubbly
rubby124413853rubb_y
rubout8313553rubout
rubus76415053ru_bus
subbed114116673subbed
subdeb1137523subdeb
subdue9128493subdue
subgum1136133subgum
suburb1037163suburb
tubbed114712223tubbed
tubber104313203tubber
tubby124511393tubb_y
tubful1136683tubful

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit112716716.67016899.0
3Display Results71710.0501420.0
 (SQL Overall)178691716.86026048.3
 
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.