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

93 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
backbit1712910(None) 
backbite1899171backbite
backfit18108211backfit
backlit15911901backlit
backbeat1847842backbeat
backbiter191786802backbiter
backbites19108632backbites
backfits19106952backfits
backlist16910652backlist
backout15612952backout
backset15314192backset
bankit123617042bank_it
hackbut1845712hackbut
sackbut1545942sackbut
acquit17610323_acquit
ambit94223713_a_mbit
babbitt1038033ba_bbitt
babysit14145613babysit
bacchic1545813bacchic
bacchii1644533bacchii
back125535763back___
backbeats1945763backbeats
backbend1944783backbend
backbiters2095583backbiters
backbiting2144293backbiting
backbitten2052893backbitten
backbone1847443backbone
backcast1887673backcast
backchat2147113backchat
backdate1748223backdate
backed155725723back_ed
backer144525523back_er
backers153821883backers
backfill1965063backfill
backfire1946003backfire
backflip2143093backflip
backhoe1847153backhoe
backing165523443backing
backlight2155703backlight
backlists17117413backlists
backlog1635773backlog
backmost1846633backmost
backouts1698643backouts
backrest1639393backrest
backs135729623back__s
backsaw1836203backsaw
backseat1648903backseat
backsets1638853backsets
backside17108143backside
backslid1746273backslid
backspin1845423backspin
backup1646613back_up
backups1736173backups
bait66556003ba___it
bandit93821133ba_ndit
bankits133410153bank_its
banksia1335943banksia
barbet104427883ba_rbet
barbie105018353ba_rbie
barbut104617003ba_rbut
barefit1249723barefit
basket125722913bask_et
becket144619883beck_et
blackbird2043573blackbird
blackboy2143163blackboy
blackest16269303blackest
blackfin1953903blackfin
blacklist1746123blacklist
blackout1647413blackout
bracket154117233brack_et
brickbat1853633brickbat
bucket144620733buck_et
cockpit1747993cockpit
cubit94122893__cubit
dacoit9415453dac_oit
dakoit11310353da_koit
gambit114714213ga_mbit
habit103027023ha__bit
hackbuts1943873hackbuts
hackie154615623hack_ie
jackboot2344783jackboot
jacket194720673jack_et
jackpot2245013jackpot
jacobin1844393jacobin
packet144726503pack_et
rabbit102914563ra_bbit
racket125229423rack_et
rarebit948423rarebit
sacbut10811943sac_but
sackbuts1644053sackbuts
tacit76333673tac__it
tacket124627493tack_et
wackest164710863wackest

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.1561145455.1
2DLD Change Limit134027936.51620568.9
3Display Results93930.0303100.0
 (SQL Overall)178691936.70226662.3
 
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.