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 “backstreet” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
backstreet185503(None) 
backstreets1952421backstreets
backrest1639393back__rest
backseat1648903backs__eat
backset15314193backs___et
backstage1845423backstage_
backstages1945013backstages
backstories1955313backstories
backstretch2461453backstretch
backstroke1763303backstroke
backstrokes1873063backstrokes
backswept2243693backs_wept
bystreet1345023b__ystreet
backbeat1847844back__beat
backdraft2154704back_draft
backdropt20124924back_dropt
backfire1946004backfir_e_
backfired2144544backfir_ed
backfires2046174backfir_es
backrests1744984back__rests
backseats1746674backs__eats
backsets1638854backs__ets
backshore2055884backshore_
backshores2145324backshores
backside17108144backs_ide_
backsides1887694backs_ides
backslide1845884backslide_
backslider1944194backslider
backslides1945264backslides
backspace2145084backspace_
backspaced2343464backspaced
backspaces2244714backspaces
backstab1845454backst__ab
backstabbed2152124backstabbed
backstabber2052124backstabber
backstabs1945474backst_abs
backstair1744684backst_air
backstairs1844474backstairs
backstamp2144194backst_amp
backstamped2452524backstamped
backstamps2243254backstamps
backstay1945964backst__ay
backstays2045654backst_ays
backstitch2352664backstitch
backstop1845564backst__op
backstopped2452524backstopped
backstops1945864backst_ops
backstory2045284backst_ory
backstretches2661014backstretches
backtrack1844244back_track
banistered1394624banistered
basketries1645044basketries
buckshee1945404bucks_hee_
buckshees2044084bucks_hees
buckteeth2051934buck_t_eeth
bystreets1442314b__ystreets
huckstered2041964huckstered
jackscrew2751814jackscr_ew
jackscrews2851524jackscrews
jacksmelt2472594jacks_melt
jackstone2244384jackstone_
jackstones2344054jackstones
jackstraw2552114jackstr_aw
jackstraws2651944jackstraws
racketeer15174634racket_eer
racketiest1643904racketiest
street64125774____street

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 Filter1786911614500.436409841.7
2DLD Change Limit161450679.37617219.5
3Display Results67670.0302233.3
 (SQL Overall)178691679.84218156.0
 
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.