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

87 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
runbacks165590(None) 
runback1556601runback_
buybacks2144782buybacks
cutbacks1845812cutbacks
finbacks1965362finbacks
outbacks1638982outbacks
ransacks1445772ransacks
rubaces1139312ru_baces
sunback1548152sunback_
unpacks1576092_unpacks
untacks1357502_untacks
backs135729623___backs
brushbacks2352033brushbacks
buyback2045533buyback_
cutback1747093cutback_
cutbanks1644313cutbanks
diebacks1745963diebacks
drawbacks2143373drawbacks
fatbacks1946003fatbacks
finback1865823finback_
fullbacks2043603fullbacks
graybacks2143823graybacks
greenbacks1953483greenbacks
gunlocks1544683gunlocks
hogbacks2044853hogbacks
humpbacks2443173humpbacks
hunchbacks2652253hunchbacks
ironbarks1542703ironbarks
jumbucks2542953jumbucks
knacks11428543_kn_acks
mudpacks1943233mudpacks
nonbanks1445033nonbanks
nonblacks1743923nonblacks
nubucks1544003nu_bucks
outback15310653outback_
outbarks1437833outbarks
paybacks2145493paybacks
pullbacks1943773pullbacks
quacks214710103qu__acks
racks115028853r___acks
ransack1346463ransack_
rebecks15288013r_ebecks
repacks15269543r_epacks
reracks132310533r_eracks
restacks1438093restacks
retacks132210713r_etacks
retracks14149103retracks
ringbarks1643483ringbarks
roebucks1643743roebucks
rollbacks1744643rollbacks
roorbacks1764653roorbacks
roughbacks2252563roughbacks
rubace10310173ru_bac_e
rubatos9278653ru_batos
rucks114422053ru___cks
rucksacks1642993rucksacks
ruddocks1643043ruddocks
rumbas102512013rumba__s
runways13134443runwa_ys
setbacks1686303setbacks
snacks124514553_sn_acks
sunbaths1344383sunbaths
sunblocks1743413sunblocks
sundecks1544253sundecks
tanbarks1445563tanbarks
tiebacks1646333tiebacks
tombacks18216463tombacks
umiacks1534013_umiacks
unbacked17268733_unbacked
unbales92914863_unbales
unbans81912623_unba_ns
unbars82113033_unba_rs
unblocks1644523_unblocks
unbraces12229413_unbraces
uncocks1537233_uncocks
undocks1436163_undocks
unlaces92513623_unlaces
unlocks1337063_unlocks
unmasks1344553_unmasks
unpack1457833_unpack_
unpicks1545183_unpicks
unstacks1446043_unstacks
untack1239763_untack_
untracks1437523_untracks
untucks1334673_untucks
wetbacks1974983wetbacks
wingbacks2144063wingbacks

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 Filter1786911461620.406440125.6
2DLD Change Limit146162876.39022873.6
3Display Results87870.0332636.4
 (SQL Overall)178691876.82926166.5
 
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.