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

115 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
foldups133273(None) 
foldup1233811foldup_
holdups1333591holdups
folders113514392folders
foldouts1244792foldouts
folds95221692fold__s
foliums1237172foliums
fondues11399312fondues
fondus105210942fondu_s
holdup1245182holdup_
blowups1433163blowups
bolds85825283bold__s
bolus79125543bol_u_s
bonducs1235553bonducs
buildups1342033buildups
cockups1735223cockups
colds85726973cold__s
coleus86818273coleu_s
collops112611753collops
colours95913443colours
coups95522473co__ups
doldrums1243053doldrums
dollops10287963dollops
dolours8438823dolours
dups75929513___dups
fillips12298133fillips
flaps105621383f_l_aps
flips105117743f_l_ips
flops105920143f_l_ops
flours94414053f_lours
flouts94315273f_louts
flubs105515443f_l_ubs
flues84626923f_l_ues
flumps135112503f_lumps
flus75626543f_l_u_s
focus105815883fo_cu_s
fodders124010753fodders
foetus958523foetu_s
fogdogs1333263fogdogs
folates103218453folates
fold86528943fold___
folded114212793fold_ed
folder104317543fold_er
folding123912443folding
foldout1149533foldout
foleys123810463fol_eys
folios93915463fol_ios
folious103710733folious
folium11310453foliu_m
folkies143612253folkies
folks126017123fol__ks
folles93820473fol_les
follies103618943follies
follis93113903fol_lis
follows13409923follows
followups1742293followups
fondles113512613fondles
fonds95824823fond__s
fondu96013973fondu__
fondue104510493fondu_e
fondued12466363fondued
foodies113416753foodies
foods95924163food__s
fops96532683fo___ps
forceps14466983forceps
fordoes11311963fordoes
fords95328183ford__s
forums114611843fo_rums
fouls87221433fo__uls
fours85521493fo__urs
fuckups1832923fuckups
fundus10429173fundu_s
goldbugs1342103goldbugs
golds75421313gold__s
goldurn943333goldurn
goldurns1042603goldurns
holders113715903holders
holdouts1245493holdouts
holds94623243hold__s
hookups1633263hookups
lockups1534243lockups
lollops9227443lollops
lookups1332953lookups
loups75319623__loups
mockups1733343mockups
modus85417203mo_du_s
molders103315553molders
molds85324833mold__s
nodus66315993no_du_s
oilcups1143333oilcups
oldies7314423_oldies
olds55926573_old__s
oleums8358783_oleums
pileups11365433pileups
polders103617373polders
polyps13479763pol_yps
polypus14346933polypus
pullups1134233pullups
roundups1143593roundups
roups75118903ro__ups
sendups10115193sendups
soldans83210403soldans
solders83517773solders
soleus64615613soleu_s
solidus8338113solidu_s
solums85211333sol_ums
solus54726983sol_u_s
soups75322943so__ups
tolus55024483tol_u_s
tossups964023tossups
voduns1035053vo_duns
walkups1633013walkups
windups1334783windups
wolds95420183wold__s
workups1633613workups

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271156.86019537.5
3Display Results1151150.0303833.3
 (SQL Overall)1786911157.31324434.7
 
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.