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

109 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
fatback183692(None) 
fastback1944521fastback
fatbacks1946001fatbacks
aback134816172_a_back
attack12148152_attack
cutback1747092cutback
fallback1944552fallback
fastbacks2044252fastbacks
finback1865822finback
hatrack1638212hatrack
outback15310652outback
payback2056452payback
scatback1875032scatback
seatback1675822seatback
setback1567142setback
wetback1875612wetback
abaca95118043_a_baca
abaci94718843_a_baci
abbacy1536623_abbacy
alack114820063_a_lack
amtrack15107393amtrack
arrack121110253_arrack
attach11118393_attach
attacks13126943_attacks
back125535763___back
bareback1846093bareback
barrack1538253barrack
buyback2045533buyback
callback1845333callback
calpack17338333calpack
carack142113173ca_rack
carjack2246153carjack
carrack1548753carrack
catface1436763catface
catwalk1645323catwalk
clawback2143843clawback
coatrack1645853coatrack
cutbacks1845813cutbacks
cutbank1545533cutbank
databank1542643databank
dieback1646913dieback
drawback2043483drawback
falbala1235873falbala
fallacy1536433fallacy
fallbacks2044353fallbacks
fastball1344913fastball
fatal84819373fat_a_l
fatbird1344033fatbird
fatstock1743613fatstock
fatwa1168063fatwa__
fatwas1249053fatwa_s
feedback2043983feedback
fetlock1645323fetlock
finbacks1965363finbacks
fireback1946953fireback
flack144519413f__lack
flapjack2642473flapjack
flareback2043183flareback
flashback2352733flashback
fullback1943853fullback
futhark1744233futhark
futtock1644153futtock
grayback2043933grayback
halfback2244243halfback
hardback2045633hardback
hatband1346823hatband
hatchback2563313hatchback
hatracks1737533hatracks
hayrack1945543hayrack
hogback1945453hogback
manpack1746063manpack
mattock1535823mattock
offtrack2042323offtrack
outbacks1638983outbacks
outbark1339453outbark
pataca10311193pat_aca
paybacks2145493paybacks
playback2144303playback
ransack1346463ransack
ratbag956563ratba_g
ratbags1035763ratbags
reattack1444123reattack
retack122612823ret_ack
retrack131310723retrack
runback1556603runback
sawbuck1843923sawbuck
scatbacks1974713scatbacks
seatbacks17115603seatbacks
setbacks1686303setbacks
slotback1644203slotback
snapback1854423snapback
softback1944223softback
stack114421693_st_ack
sunback1548153sunback
swayback2243683swayback
tack106536293__t_ack
tailback1644923tailback
talkback1543933talkback
tambac122210243tambac_
tambacs13219363tambacs
tambak14249263tamba_k
tanbark1337373tanbark
thack144915173__thack
tieback1547103tieback
tomback17227743tomback
track114823013__track
untack1239763unt_ack
untrack1338703untrack
wetbacks1974983wetbacks

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.436409841.7
2DLD Change Limit1340271097.08018930.4
3Display Results1091090.0303633.3
 (SQL Overall)1786911097.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.