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

94 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
backfits1910695(None) 
backfit18108211backfit_
backbit17129102backbit_
backbite1899172backbite
backbites19108632backbites
backfill1965062backfill
backfills20104652backfills
backfire1946002backfire
backfires2046172backfires
backflips2243332backflips
backlist16910652backlist
backlists17117412backlists
backlit15911902backlit_
backouts1698642backouts
backsets1638852backsets
bankits133410152bank_its
blackfins2054392blackfins
acquits1857293_acquits
babysits15143543babysits
bacchius1744713bacchius
backbeats1945763backbeats
backbiter191786803backbiter
backbiters2095583backbiters
backcast1887673backcast
backcasts1985423backcasts
backchats2245313backchats
backdate1748223backdate
backdates1848153backdates
backers153821883back_ers
backfield2143383backfield
backfields2252213backfields
backfired2144543backfired
backfitted2253253backfitted
backflip2143093backflip
backflow2243373backflow
backflows2343873backflows
backhoes1938543backhoes
backing165523443back_ing
backings174012213backings
backless162910633backless
backlights2253993backlights
backlogs1746633backlogs
backmost1846633backmost
backout15612953backout_
backrest1639393backrest
backrests1744983backrests
backs135729623back___s
backsaws1946803backsaws
backseats1746673backseats
backset15314193backset_
backside17108143backside
backsides1887693backsides
backspins1945703backspins
backups1736173back_ups
baffies153612943ba_ffies
baits76630583ba___its
bandits103814793ba_ndits
bankit123617043bank_it_
banksias1445893banksias
barefit1249723barefit_
basifies13310493basifies
baskets135111833bask_ets
beckets15399823beck_ets
befits114711503b__efits
benefits1345713benefits
blackfin1953903blackfi_n
blackfish2343833blackfish
blackflies2143733blackflies
blacklist1746123blacklist
blacklists1844183blacklists
blackouts1745153blackouts
brackets163310433brack_ets
buckets153811693buck_ets
cockpits1845743cockpits
dacoits1079073dac_oits
dakoits1245293da_koits
hackbuts1943873hackbuts
hackies163418243hack_ies
haffits1636193ha_ffits
jackets205011373jack_ets
jackfish2744123jackfish
jackfruits2651323jackfruits
jackies202912623jack_ies
jackpots2344003jackpots
pacifies15311223pacifies
pacifist1548093pacifist
pacifists1645063pacifists
packets155114773pack_ets
rackets134916873rack_ets
rackfuls1744643rackfuls
sackbuts1644053sackbuts
sackfuls1744163sackfuls
tackets134914363tack_ets
tackifies1845783tackifies

Search took 10 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.436409841.7
2DLD Change Limit146162948.80016609.3
3Display Results94940.0601566.7
 (SQL Overall)178691949.29619222.4
 
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.