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

198 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
backups173617(None) 
backup1646611backup_
backers153821882backers
backouts1698642backouts
backs135729622back__s
cockups1735222cockups
crackups1843122crackups
fuckups1832922fuckups
kickups1443502kickups
lockups1534242lockups
markups1534962markups
mockups1733342mockups
pickups1754252pickups
stackups1643312stackups
walkups1633012walkups
abacus10349763abac_u_s
ackees124914583_ackees
ankus91410683_anku_s
baaskaps1641953baaskaps
babkas146010143babk_as
babuls105413643ba_buls
babus95620333ba_bu_s
baches135426943bac_hes
back125535763back___
backbit17129103backbit
backcast1887673backcast
backdrops20144403backdrops
backed155725723back_ed
backer144525523back_er
backfit18108213backfit
backfits19106953backfits
backflips2243333backflips
backhauls2044863backhauls
backhoe1847153backhoe
backhoes1938543backhoes
backing165523443backing
backings174012213backings
backlash1945923backlash
backless162910633backless
backlist16910653backlist
backlit15911903backlit
backlog1635773backlog
backlogs1746633backlogs
backmost1846633backmost
backout15612953backout
backrest1639393backrest
backrush1944103backrush
backsaw1836203backsaw
backsaws1946803backsaws
backset15314193backset
backsets1638853backsets
backslaps1945253backslaps
backspin1845423backspin
backspins1945703backspins
backstops1945863backstops
backwash2244943backwash
backwraps2244193backwraps
bacons104917583bac_ons
bacula103112673bac_ula
baculums1443723baculums
bagfuls1334753bagfuls
bakers125323453ba_kers
bakes117035373ba_k_es
balkers134915723balkers
balks114926293balk__s
bankers133919093bankers
bankits133410153bankits
bankrupt1643243bankrupt
bankrupts1741893bankrupts
banks115527903bank__s
baps86040843ba___ps
barbuts11439843barbuts
barhops14288113barhops
bariums1139143bariums
barkeeps1634143barkeeps
barkers134318513barkers
barks115735813bark__s
barques18259643barques
baskets135111833baskets
basks115621763bask__s
basques18248673basques
battues94610193battues
bauds85821043ba__uds
bayous11411153bayou_s
beaucoups1541763beaucoups
becaps123811403bec_aps
beckets15399823beckets
beckons15279143beckons
becks135522013beck__s
biceps12447713bic_eps
bickers154316553bickers
blackcaps2143353blackcaps
blackens16388103blackens
blackgums2042543blackgums
blackouts1745153blackouts
blacks144914953black__s
blacktops1943373blacktops
blowups1433163blowups
bocks134526573bock__s
brackens16327923brackens
brackets163310433brackets
breakups1642513breakups
buckers153517453buckers
buckets153811693buckets
buckles153416093buckles
buckoes153810393buckoes
buckos143710893buck_os
buckras1537343buckras
bucks134824293buck__s
bunkums1544053bunkums
bupkus14385683bupku_s
cackles153717203cackles
cactus104912233cactu_s
catchups1744383catchups
catsups1135343catsups
checkups2142803checkups
cockup1635713cockup_
coups95522473__coups
crackup1743563crackup_
cups85430823__c_ups
dackers143417043dackers
faceup1334893faceup_
fuckup1733963fuckup_
hackbuts1943873hackbuts
hackees165014103hackees
hackers164619043hackers
hackies163418243hackies
hackles162917063hackles
hacks144928713hack__s
haikus13538293haiku_s
hakus125114113ha_ku_s
hangups1364813hangups
hiccups1643223hiccups
hookups1633263hookups
jackals2036893jackals
jackass2034963jackass
jackers204214453jackers
jackets205011373jackets
jackies202912623jackies
jacks185219833jack__s
jaups144810533ja__ups
kickup1354133kickup_
lackers134120543lackers
lackeys16458263lackeys
lacks116129203lack__s
larrups934733larrups
layups1133993la_yups
linkups1333633linkups
lockup1434763lockup_
lookups1332953lookups
mackles154415753mackles
macks135127603mack__s
makeups1533603makeups
markup1436903markup_
matchups1743073matchups
mockup1634073mockup_
oakums1264153oa_kums
packers153818893packers
packets155114773packets
packs135528933pack__s
pickup1655633pickup_
rackers134320453rackers
rackets134916873rackets
rackfuls1744643rackfuls
racks115028853rack__s
rakus94413673ra_ku_s
recoups1188843recoups
ruckus12407793rucku_s
sacbuts1166473sacbuts
sackbuts1644053sackbuts
sackers133820223sackers
sackfuls1744163sackfuls
sacks114228873sack__s
sacques18106863sacques
sacrums11388043sacrums
sannups934463sannups
scaups105411933_scaups
scups95316653_sc_ups
stackup1533743stackup_
stickups1643303stickups
tackers134319623tackers
tackets134914363tackets
tackles133816523tackles
tacks115430133tack__s
takeups1333403takeups
teacups1133963teac_ups
vacuums1443403vacuums
wackes154717713wack_es
wackos155210993wack_os
wacks146626283wack__s
walkup1534193walkup_
warmups1433813warmups
washups1534683washups
wickiups19181963wickiups
wickyups22171773wickyups
workups1633613workups
yacks144419813yack__s
yaups105910743ya__ups

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271986.12621878.4
3Display Results1981980.0762605.3
 (SQL Overall)1786911986.60827041.6
 
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.