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

62 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
backsides188769(None) 
backside17108141backside_
backslides1945261backslides
banksides16104851banksides
backbites19108632backbites
backfires2046172backfires
backslide1845882backslide_
backslider1944192backslider
backsliders2052782backsliders
bankside15115652bankside_
docksides17154282docksides
tracksides1744162tracksides
apsides103911303_a_psides
asides75118873_a__sides
backaches22146813backaches
backbite1899173backbite_
backbiter191786803backbiter
backbiters2095583backbiters
backbones1947253backbones
backdates1848153backdates
backfills20104653backfills
backfire1946003backfire_
backfired2144543backfired
backfits19106953backfi_ts
backhoes1938543back_hoes
backings174012213back_ings
backlists17117413backlists
backsaws1946803backs_aws
backseats1746673backseats
backset15314193backs__et
backsets1638853backs_ets
backshores2145323backshores
backslaps1945253backslaps
backslid1746273backslid__
backslidden2192223backslidden
backspaces2244713backspaces
backspins1945703backspins
backstabs1945473backstabs
backstages1945013backstages
backstays2045653backstays
backstops1945863backstops
backswings2243113backswings
balklines1536743balklines
banksias1445893banksi_as
beachside1743063beachside_
bedsides1246533b_edsides
besides104814533b__esides
buckshees2044083buckshees
burnsides1244233burnsides
daysides1335963da_ysides
dockside16154743dockside_
farsides1237993fa_rsides
hackies163418243hack_i_es
jackies202912623jack_i_es
jacksnipes2551963jacksnipes
lakesides1444093lakesides
landsides11116743landsides
rachides141511223rac_hides
rockslides1752773rockslides
trackside1644373trackside_
waysides1544453wa_ysides
weaksides1742473weaksides

Search took 8 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.403443402.0
2DLD Change Limit148641627.11020905.9
3Display Results62620.0331878.8
 (SQL Overall)178691627.54623680.2
 
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.