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

135 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
sunback154815(None) 
runback1556601runback
buyback2045532buyback
cutback1747092cutback
finback1865822finback
outback15310652outback
runbacks1655902runbacks
setback1567142setback
snack114718062s_n_ack
sunbath1236422sunbath
sunblock1643762sunblock
sundeck1445272sundeck
unpack1457832_unpack
untack1239762_untack
aback134816173__aback
back125535763___back
buybacks2144783buybacks
cutbacks1845813cutbacks
cutbank1545533cutbank
dieback1646913dieback
fatback1836923fatback
finbacks1965363finbacks
fullback1943853fullback
gunlock1444563gunlock
hogback1945453hogback
humpback2343593humpback
hunchback2552263hunchback
jumbuck2443273jumbuck
knack104311043_kn_ack
lunacy1136843lun_acy
manpack1746063manpack
mudpack1843593mudpack
nonbank1345903nonbank
nonblack1644303nonblack
nubuck1434543nu_buck
outbacks1638983outbacks
outbark1339453outbark
payback2056453payback
pullback1844243pullback
quack203812503qu__ack
ransack1346463ransack
rubace10310173ru_bace
sack105337313s___ack
sandbank1544873sandbank
sanjak1735693sanja_k
sawbuck1843923sawbuck
scatback1875033scatback
seatback1675823seatback
setbacks1686303setbacks
shack145321753s__hack
skewback1843903skewback
skyjack2242763skyjack
slack115021763s__lack
slingback1852453slingback
slotback1644203slotback
smack134615453s__mack
snacks124514553s_n_acks
snapback1854423snapback
snark95419943s_n_ark
sneak96016173s_nea_k
sneck114713663s_n_eck
snick114416013s_n_ick
snuck114411913s_n_uck
softback1944223softback
stack114421693s__tack
suba64926603su_ba__
subacid1248473su_bacid
subah106015213su_ba_h
subahs114512383su_bahs
subas74724073su_ba_s
subbase1139323subbase
subbass1138033subbass
subblock1843673subblock
subrace11313003subrace
subtask1335713subtask
suck106131733su___ck
sumac99514883su_mac_
sumach135310113su_mach
sumacs105512103su_macs
sunbaked1545533sunbaked
sunbathe1344033sunbathe
sunbaths1344383sunbaths
sunbeam1146053sunbeam
sunbeams1243963sunbeams
sunbeamy1542353sunbeamy
sunbelt939233sunbelt
sunbird1044743sunbird
sunblocks1743413sunblocks
sunbow1145823sunb_ow
sunbows1236023sunbows
sunburn945133sunburn
sundae7312873sunda_e
sundaes8313093sundaes
sundecks1544253sundecks
sunfast1038503sunfast
sunk85031813sun___k
sunlamp1144163sunlamp
sunland837473sunland
sunna55016063sunna__
sunnah9369353sunna_h
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunray9310123sunra_y
sunrays1037083sunrays
suntan62613003sunta_n
suntans72111733suntans
sunward1137653sunward
surbase939793surbase
surface1238653surface
swayback2243683swayback
tanbark1337373tanbark
tieback1547103tieback
tomback17227743tomback
umiack1435173_umiack
unbacked17268733_unbacked
unbale83616403_unbale
unban72114333_unba_n
unbans81912623_unbans
unbar71913613_unba_r
unbars82113033_unbars
unblock1545793_unblock
unbrace111910493_unbrace
uncock1438563_uncock
undock1337703_undock
unlace82215173_unlace
unlock1248533_unlock
unmask1265903_unmask
unpacks1576093_unpacks
unpick1446903_unpick
unstack1337373_unstack
untacks1357503_untacks
untrack1338703_untrack
untuck1236403_untuck
wetback1875613wetback
wingback2044403wingback

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 Limit1340271355.93622578.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.38827972.9
 
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.