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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
paybacks214549(None) 
payback2056451payback_
playbacks2244131playbacks
buybacks2144782buybacks
fatbacks1946002fatbacks
graybacks2143822graybacks
hayracks2045312hayracks
playback2144302playback_
swaybacks2343582swaybacks
abacas104414723_a_bacas
aback134816173_a_back_
abacus10349763_a_bacus
arracks1387733_arracks
attacks13126943_attacks
backs135729623___backs
barracks1636883barracks
buyback2045533buyback_
callbacks1945023callbacks
calpacks18266523calpacks
caracks152211563ca_racks
carjacks2345573carjacks
carracks1637713carracks
carrybacks2352113carrybacks
clawbacks2243623clawbacks
claybanks2042413claybanks
cutbacks1845813cutbacks
daybooks1843983daybooks
diebacks1745963diebacks
drawbacks2143373drawbacks
fallbacks2044353fallbacks
fastbacks2044253fastbacks
fatback1836923fatback_
finbacks1965363finbacks
grayback2043933grayback_
halfbacks2343993halfbacks
hardbacks2145373hardbacks
hatracks1737533hatracks
haycocks2244113haycocks
hayrack1945543hayrack_
hayricks2043763hayricks
haystacks2143373haystacks
hogbacks2044853hogbacks
jaywalks2542143jaywalks
kayaks1236333kay_a_ks
kyacks14416063_ky_acks
outbacks1638983outbacks
packs135528933p___acks
packsacks1844253packsacks
padauks1443943pa_dauks
paddocks1894323paddocks
paddywacks2651223paddywacks
padlocks1755473padlocks
palaces114216453pa_laces
paperbacks2243713paperbacks
parbake1538353parba_ke
parbakes1638343parbakes
patacas11311003pa_tacas
payables15166483payables
paychecks2542243paychecks
paydays1634433payda_ys
piggybacks2551553piggybacks
placks144414153p__lacks
playacts1543813play_acts
playbooks2043373playbooks
plowbacks2243123plowbacks
pollacks1656373pollacks
prepacks1836583prepacks
pullbacks1943773pullbacks
ransacks1445773ransacks
runbacks1655903runbacks
sawbucks1943413sawbucks
scatbacks1974713scatbacks
seatbacks17115603seatbacks
setbacks1686303setbacks
skyjacks2342543skyjacks
snapbacks1954303snapbacks
swayback2243683swayback_
tailbacks1744423tailbacks
talkbacks1643783talkbacks
tambacs13219363tambac_s
tambaks15218153tamba_ks
tanbarks1445563tanbarks
tiebacks1646333tiebacks
tombacks18216463tombacks
wetbacks1974983wetbacks
yacks144419813__y_acks

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 Filter1786911461620.420425454.8
2DLD Change Limit146162867.09320606.5
3Display Results86860.0332606.1
 (SQL Overall)178691867.54623680.2
 
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.