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 “holdup” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

178 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
holdup124518(None) 
foldup1233811foldup
holdups1333591holdups
foldups1332732foldups
hold86235062hold__
holden104113952holden
holder104619652holder
holdout11510892holdout
holds94623242hold_s
holp95727552hol__p
hookup1534422hookup
ahold94714253ahold__
aholds10469483ahold_s
blowup1335063blowup
bold75432813bold__
bolder94820933bolder
boldly12399423boldly
bolds85825283bold_s
bolus79125543bol_us
bonduc1136603bonduc
buildup1242333buildup
cockup1635713cockup
cold77338773cold__
colder95121833colder
coldly12459953coldly
colds85726973cold_s
coleus86818273coleus
collop107312313collop
colour85915083colour
coup86729793co__up
dollop9259363dollop
dolour75710133dolour
dup67637883___dup
fold86528943fold__
folded114212793folded
folder104317543folder
foldout1149523foldout
folds95221693fold_s
folium11310453folium
fondu96013973fondu_
fondue104510493fondue
fondus105210943fondus
gold65430163gold__
goldbug1242103goldbug
golden84411153golden
golder84417603golder
golds75421313gold_s
goldurn943323goldurn
hallux1637363hallux
hangup1277293hangup
held85330403held__
helium112311253helium
help95328923hel__p
hiccup1554393hiccup
hilum105514603hil_um
hilus84817643hil_us
hocus104715203ho_cus
hod76852463ho_d__
hodad10311353ho_dad
hodden113811453hodden
hoddin11369933hoddin
hods87239863ho_d_s
hoed87837983hoed__
hognut1039413hognut
hoiden103612333hoiden
hokku1135483hokku_
hokum1436763ho_kum
holard10410573holard
holdall1145473holdall
holders113715903holders
holding123514283holding
holdouts1245473holdouts
hole77553393hol__e
holed95634133hol_ed
holes84748653hol_es
holey115626903hol_ey
holibut1297483holibut
holiday1436143holiday
holier94921623holier
holies94630033holies
holily123612953holily
holing104025073holing
holism113713743holism
holist94723213holist
holk116027943hol__k
holked144913663holked
holks124720563hol_ks
holla84918493hol_la
hollas94616903hollas
holler93520613holler
hollo84822163hol_lo
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holly114824433hol_ly
holm95628103hol__m
holmic1338773holmic
holmium1445433holmium
holms105117803hol_ms
holpen11299413holpen
hols76946293hol__s
holt77852583hol__t
holts85627913hol_ts
holy106333433hol__y
holyday1743773holyday
honda9414983hond_a
hondas10313353hondas
hondle103914523hondle
honour94710863honour
hood85132333hood__
hooded114616743hooded
hoodie105116133hoodie
hoodlum1343813hoodlum
hoodoo10109983hoodoo
hoods95124083hood_s
hoody124919723hood_y
hookups1633263hookups
hoop96129983ho__op
hop87554593ho___p
horde94623053hord_e
horded115420483horded
hordes104921633hordes
hotdog1134793hotdog
houdah1335173houdah
hour75827313ho__ur
howdah1634723howdah
howdie13349723howdie
howdy155711413howd_y
hoyden13328933hoyden
hup86437813h___up
lockup1434763lockup
lollop8238783lollop
lookup1233453lookup
loup66028433__loup
mockup1634073mockup
modus85417203mo_dus
mold76034333mold__
molded104414083molded
molder93819273molder
molds85324833mold_s
moldy115014653mold_y
nodus66315993no_dus
oilcup1044253oilcup
old47033463_old__
olden65114853_olden
older65121173_older
oldie6415473_oldie
olds55926573_old_s
oldy85316843_old_y
oleum73613323_oleum
pileup10437923pileup
polder94019253polder
polyp125611533pol_yp
pullup1045893pullup
roundup1044053roundup
roup66627693ro__up
sendup9106343sendup
sold54837413sold__
soldan73511853soldan
solder73921343solder
soldi65717193sold_i
soldo67116563sold_o
soleus64615613soleus
solidus8338113solidus
solum74717603sol_um
solus54726983sol_us
soup66232913so__up
told56132203told__
tolu45529153tol_u_
tolus55024483tol_us
tossup875293tossup
vodun937223vo_dun
walkup1534193walkup
windup1235383windup
wold85429073wold__
wolds95420183wold_s
workup1534323workup

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 Limit1127161786.68616858.5
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.88925938.6
 
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.