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

86 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
hiccup155439(None) 
hiccups1643221hiccups
hiccuped1861882hiccuped
kickup1354132kickup
oilcup1044252oilcup
pickup1655632pickup
backup1646613backup
bicep115413543bi_cep
checkup2043323checkup
chirrup14123833chirrup
circus104310593circus
coccus979283coccus
cockup1635713cockup
coup86729793__coup
cup76738243___cup
dictum1136863dictum
discus94512113discus
eggcup1241833eggcup
eyecup1344493eyecup
faceup1334893faceup
fichu134810663fichu_
fichus14388113fichus
ficus105015493fi_cus
fuckup1733963fuckup
haircap14134753haircap
haircut1246833haircut
hangup1277293hangup
hiatus938223hiatus
hic86540563hi_c__
hiccough1951343hiccough
hiccuping1942203hiccuping
hiccupped2141313hiccupped
hick135530303hi_c_k
hickey185011993hickey
hickie153812473hickie
hicks145322173hi_cks
hilum105514603hi_lum
hilus84817643hi_lus
hip86750433hi___p
hitch134515473hitc_h
hocus104715203h_ocus
holdup1245183holdup
hookup1534423hookup
hubcap1553993hubcap
hup86437813h___up
icecap1245223_icecap
ictus7249703_ictus
incur72212253_incur
incus73315053_incus
kickups1443503kickups
kingcup1642473kingcup
lineup835983lineup
linkup1245123linkup
lockup1434763lockup
midcap1336473midcap
miscue10412223miscue
miscut10614813miscut
mixup1636773mi_xup
mockup1634073mockup
occupy1543153_occupy
occur9137323_occur
oilcups1143333oilcups
pickups1754253pickups
picul95015363pi_cul
pileup10437923pileup
pinup9612883pi_nup
recoup10810373recoup
rictus8379193rictus
scaup95515993_scaup
scup84822383__scup
siccan1037593siccan
sicced11489653sicced
sirup74014913si_rup
situp74414063si_tup
stickup1533853stickup
teacup1036253teacup
ticced11438443ticced
tittup834203tittup
viscus11428503viscus
wicca1247253wicc_a
wiccan1335033wiccan
wiccas1336543wiccas
wickiup18172673wickiup
wickyup21171883wickyup
wikiup15183533wikiup
windup1235383windup

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.1431249587.4
2DLD Change Limit112716866.01318745.4
3Display Results86860.0332606.1
 (SQL Overall)178691866.18928872.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.