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

89 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
backfit1810821(None) 
backbit17129101backbit
backfits19106951backfits
backlit15911901backlit
backbite1899172backbite
backfill1965062backfill
backfire1946002backfire
backflip2143092backflip
backlist16910652backlist
backout15612952backout
backset15314192backset
bankit123617042bank_it
barefit1249722barefit
blackfin1953902blackfin
acquit17610323_acquit
babysit14145613babysit
bacchic1545813bacchic
bacchii1644533bacchii
back125535763back___
backbeat1847843backbeat
backbiter191786803backbiter
backbites19108633backbites
backcast1887673backcast
backchat2147113backchat
backdate1748223backdate
backed155725723back_ed
backer144525523back_er
backers153821883backers
backfield2143383backfield
backfills20104653backfills
backfired2144543backfired
backfires2046173backfires
backfitted2253253backfitted
backflips2243333backflips
backflow2243373backflow
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
basket125722913bask_et
becket144619883beck_et
befit105222663b__efit
benefit1248073benefit
blackest16269303blackest
blackfins2054393blackfins
blackfish2343833blackfish
blackfly2243013blackfly
blacklist1746123blacklist
blackout1647413blackout
bracket154117233brack_et
bucket144620733buck_et
cockpit1747993cockpit
dacoit9415453dac_oit
dakoit11310353da_koit
hackbut1845713hackbut
hackie154615623hack_ie
haffit1538533ha_ffit
jacket194720673jack_et
jackfish2744123jackfish
jackfruit2552123jackfruit
jackpot2245013jackpot
pacific1646913pacific
pacifist1548093pacifist
packet144726503pack_et
racket125229423rack_et
rackful1645873rackful
sackbut1545943sackbut
sackful1645353sackful
tacit76333673tac__it
tacket124627493tack_et
tackify1934493tackify
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.403443402.0
2DLD Change Limit134027896.50020619.5
3Display Results89890.0332697.0
 (SQL Overall)178691896.93625762.8
 
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.