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

87 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
hubcap155399(None) 
hubcaps1643541hubcaps
mobcap1444112mobcap
mudcap1335132mudcap
uncap9312282_uncap
bap76455843__b_ap
becap114315053_becap
bluecap1343113bluecap
bobcat12411253bobcat
bubal94218213bub_al
bubba84311803bubba_
bubbas94110703bubbas
buccal1248243buccal
burlap1098353burlap
cap76758983___cap
cubical1338463cubical
ducal84816423du_cal
ducat86225903du_cat
fubar1039923fub_ar
gelcap1136213gelcap
haircap14134753haircap
hap87360053h___ap
heap96432893h__eap
hepcat13611823hepcat
hiccup1554393hiccup
hub86437483hub___
hubbly16478413hubbly
hubbub1243603hubbub
hubby155011403hub_by
hubris11218973hubris
hubs96027143hub__s
huck135927633hu_c_k
hucks144322173hu_cks
huic94818053huic__
hula74923753hu_la_
hulas84920883hu_las
human102716033hu_man
hump116228723hu__mp
hunch136416213hunc_h
hup86437813hu___p
huppah1644183huppah
hurrah12369183hurrah
hurray12459913hurray
hussar9317283hussar
hutch135414093hutc_h
hutzpa2052813hutzpa
huzza1646093huzza_
huzzah2044423huzzah
huzzas1735863huzzas
icecap1245223icecap
juba134916983jub_a_
jubas144614223jub_as
jubbah2034353jubbah
jubhah2142803jubhah
madcap1336333madcap
midcap1336473midcap
mobcaps1543463mobcaps
mudcaps1444103mudcaps
mudcat11311203mudcat
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
nubia7311233nubia_
nubias8310093nubias
recap95718023_recap
redcap1158493redcap
rubace10310173rubace
skycap1742913skycap
suba64926603sub_a_
subah106015213sub_ah
subas74724073sub_as
subclan1147173subclan
subpar1048663subpar
subway1447073subway
succah1336643succah
sulcal8311273sulcal
toecap1037323toecap
tuba65422363tub_a_
tubae74716643tub_ae
tubal75517203tub_al
tubas75119583tub_as
uncaps1039813_uncaps
webcam1545543webcam
yuca95716723yu_ca_
yucas106013913yu_cas
yucca12467443yucca_
yuccas13426553yuccas

Search took 5 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.1261418182.5
2DLD Change Limit112716874.48325143.0
3Display Results87870.0332636.4
 (SQL Overall)178691874.64238494.4
 
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.