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

128 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
backout1561295(None) 
backouts1698641backouts
blackout1647411blackout
backbit17129102backbit
backcourt1944982backcourt
backfit18108212backfit
backlit15911902backlit
backmost1846632backmost
backset15314192backset
backup1646612back_up
bailout9414132bailout
blackouts1745152blackouts
hackbut1845712hackbut
lockout1359332lockout
sackbut1545942sackbut
sickout1359372sickout
walkout1447932walkout
about75229083_a_bout
accost101112263_accost
account11109043_account
back125535763back___
backbeat1847843backbeat
backbite1899173backbite
backbone1847443backbone
backcast1887673backcast
backchat2147113backchat
backcourts2052923backcourts
backdate1748223backdate
backdoor1744693backdoor
backdropt20124923backdropt
backed155725723back_ed
backer144525523back_er
backers153821883backers
backfits19106953backfits
backhaul1945133backhaul
backhoe1847153backhoe
backhoed2047013backhoed
backhoes1938543backhoes
backhouse2046143backhouse
backing165523443backing
backlist16910653backlist
backload1746833backload
backlog1635773backlog
backlogs1746633backlogs
backrest1639393backrest
backroom1846093backroom
backrush1944103backrush
backs135729623back__s
backsaw1836203backsaw
backseat1648903backseat
backsets1638853backsets
backups1736173backups
backwood2046973backwood
bacon95620593bac_o_n
bacons104917583bac_ons
baculum1345703baculum
badmouth1643583badmouth
bailouts1036613bailouts
ballot84624093ballo_t
bankit123617043bank_it
bankrupt1643243bankrupt
barbut104617003ba_rbut
basket125722913bask_et
bayou10512363ba_you_
bayous11411153ba_yous
becket144619883beck_et
beckon14309383becko_n
beckons15279143beckons
becloud1246293becloud
beshout12311833beshout
blackest16269303blackest
blackgum1942513blackgum
blowout1248403blowout
bout66353293b___out
bracket154117233brack_et
breakout1456283breakout
bucket144620733buck_et
bucko134614023bucko__
buckoes153810393buckoes
buckos143710893bucko_s
bugout9311863b_ugout
burgout1049773burgout
burnout9310453burnout
buyout11310103b_uyout
cachou13310623cachou_
cachous14312583cachous
campout13412853campout
checkout1945593checkout
clout75330463__clout
cookout13410153cookout
dacoit9415453dac_oit
dakoit11310353da_koit
fadeout11410193fadeout
fallout10313503fallout
hackbuts1943873hackbuts
handout11314103handout
hangout11411393hangout
jackboot2344783jackboot
jacket194720673jack_et
jackpot2245013jackpot
knockout1343893knockout
layout9513703la_yout
locknut1345253locknut
lockouts1445493lockouts
lookout1148033lookout
mahout11415803ma_hout
packet144726503pack_et
payout11714653pa_yout
racket125229423rack_et
rackful1645873rackful
ragout7317183ra_gout
rainout7314393rainout
sacbut10811943sac_but
sackbuts1644053sackbuts
sackful1645353sackful
scout75031453_sc_out
sickouts1455503sickouts
stickout1476333stickout
tacket124627493tack_et
takeout1149873takeout
vacuous1237023vacuous
wackest164710863wackest
wacko145514383wacko__
wackos155210993wacko_s
walkouts1544253walkouts
washout13410133washout
watchout1647013watchout
workout1448393workout

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.423422437.4
2DLD Change Limit1340271285.76323256.5
3Display Results1281280.0502560.0
 (SQL Overall)1786911286.23628654.7
 
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.