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

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
backwards214746(None) 
backward2048101backward_
backyards2146531backyards
backboards2146192backboards
backhands2146302backhands
backlands1846822backlands
backswords2243812backswords
backwardly2552572backwardly
backwoods2146392backwoods
backwraps2244192backwraps
backyard2046842backyard_
bankcards1873782bankcards
becowards1743842becowards
awards107113453_a__wards
awkward1843183_awkward_
baccaras1446913bac_caras
backbends2044093backbends
backboard2047183backboard_
backcasts1985423backcasts
backdates1848153backdates
backers153821883back_er_s
backfires2046173backfires
backhand2047433backhand_
backhauls2044863backhauls
backland1748103backland_
backloads1846293backloads
backpacks2044993backpacks
backsaws1946803backsa_ws
backsword2144623backsword_
backwardness2481833backwardness
backwash2244943backwa_sh
backwashes24104673backwashes
backwater2096753backwater
backwaters2195163backwaters
backwood2046973backwood_
backwoodsy2552163backwoodsy
backwrap2144073backw_rap
bakewares1845043bakewares
ballyards1544993ballyards
bankcard1774023bankcard_
barnyards1543493barnyards
barwares13610093ba_rwares
bastards113310313ba_stards
bayards13379683ba__yards
becoward1644763becoward_
bedwards1596393b_edwards
blackbirds2143253blackbirds
blackboards2253833blackboards
blackguards2162283blackguards
blacklands1944123blacklands
blackwoods2243893blackwoods
brickyards2252143brickyards
buckboards2143613buckboards
cowards1339613__cowards
dockyards2042983dockyards
eastwards1344253eastwards
hackworks2045203hackworks
haywards1845873ha_ywards
jacquards2842683jacquards
landwards1445503landwards
manwards1447613ma_nwards
packboards2144443packboards
packwaxes2743413packwaxes
rackworks1745543rackworks
tackboards1944363tackboards
tankards1366253tank_ards
vawards14457573va__wards

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641678.45317584.4
3Display Results67670.0631063.5
 (SQL Overall)178691678.67220605.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.