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

157 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
foldup123381(None) 
foldups1332731foldups
holdup1245181holdup
fold86528942fold__
folded114212792folded
folder104317542folder
foldout1149522foldout
folds95221692fold_s
folium11310452folium
fondu96013972fondu_
fondue104510492fondue
fondus105210942fondus
holdups1333592holdups
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
faceup1334893faceup
fillip11268953fillip
filum105015433fil_um
flap96128703f_l_ap
flip96324263f_l_ip
flop96925453f_l_op
flour84916453f_lour
flout86226203f_lout
flu66530213f_l_u_
flub95721883f_l_ub
flue75329853f_l_ue
flump124614723f_lump
flus75626543f_l_us
flux145617743f_l_ux
focus105815883fo_cus
fodder114712113fodder
foetus958523foetus
fogdog1234223fogdog
folate93320393folate
folders113514393folders
folding123912443folding
foldouts1244773foldouts
foley115222303fol_ey
foleys123810463foleys
folia83618933fol_ia
foliar93210973foliar
folic105319323fol_ic
folio83820883fol_io
folios93915463folios
folious103710733folious
foliums1237173foliums
folk116021543fol__k
folkie13369613folkie
folks126017123fol_ks
folksy16484983folksy
folky159214713fol_ky
folles93820473folles
follis93113903follis
follow124010353follow
followup1642173followup
folly115022603fol_ly
fond86330953fond__
fonded115717043fonded
fonder104120063fonder
fondle104412943fondle
fondly13299043fondly
fonds95824823fond_s
fondued12466363fondued
fondues11399313fondues
food86830573food__
foodie104413843foodie
foods95924163food_s
fop86743703fo___p
ford86835493ford__
forded115020393forded
fordid113512053fordid
fordo97218653ford_o
fords95328183ford_s
forum108318763fo_rum
fou66743783fo__u_
foul77027583fo__ul
four76226863fo__ur
fuckup1733963fuckup
fundus10429173fundus
gold65430163gold__
goldbug1242103goldbug
golden84411153golden
golder84417603golder
golds75421313gold_s
goldurn943323goldurn
hold86235063hold__
holden104113953holden
holder104619653holder
holdout11510893holdout
holds94623243hold_s
holp95727553hol__p
hookup1534423hookup
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.1231452772.4
2DLD Change Limit1127161576.33017806.6
3Display Results1571570.0762065.8
 (SQL Overall)1786911576.52927368.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.