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

58 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
backmost184663(None) 
backcast1887672backcast
backlist16910652backlist
backout15612952back_out
backrest1639392backrest
accost101112263_ac_cost
aftmost1244973_aftmost
almost81014433_a_lmost
backbeat1847843backbeat
backbit17129103back_bit
backbone1847443backbone
backcasts1985423backcasts
backchat2147113backchat
backcourt1944983backcourt
backcross1943923backcross
backdoor1744693backdoor
backdropt20124923backdropt
backers153821883backers_
backfit18108213back_fit
backfits19106953backfits
backhoe1847153backho_e
backhoed2047013backhoed
backhoes1938543backhoes
backhouse2046143backhouse
backlash1945923backlash
backless162910633backless
backlists17117413backlists
backlit15911903back_lit
backload1746833backload
backlog1635773backlo_g
backlogs1746633backlogs
backouts1698643back_outs
backrests1744983backrests
backroom1846093backroom
backrush1944103backrush
backs135729623back__s_
backseat1648903backseat
backset15314193back_set
backsets1638853backsets
backups1736173backups_
backwash2244943backwash
backwood2046973backwood
balkiest144112453balkiest
barkiest144115153barkiest
bayamos1434663bayamos_
blackest16269303black_est
blacklist1746123blacklist
blackout1647413black_out
buckos143710893buck_os_
jackboot2344783jackboot
jackpot2245013jackpo_t
jackpots2344003jackpots
oakmoss1342533oa_kmoss
racemose1245003racemose
tackiest143112433tackiest
wackest164710863wack_est
wackiest172610273wackiest
wackos155210993wack_os_

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 Filter1786911461620.423422437.4
2DLD Change Limit146162586.45322650.2
3Display Results58580.0301933.3
 (SQL Overall)178691586.90625874.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.