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

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

43 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
backscatterings26977(None) 
backscattering2581151backscattering_
backscatters2252053backscatter___s
backscatter2152674backscatter____
backscattered247864backscatter__ed
scatterings14103974____scatterings
backstabbings2361175backs__tabbings
bespattering1752345b__espattering_
scattering1398015____scattering_
smatterings14103845____smatterings
accoutering1653206_ac__coutering_
backbitings2252336back__bit__ings
backdating2045716back_da_t__ing_
backfitting2353076back_fitt__ing_
backslappers2451896backslapper___s
backslapping2552086backsla__pping_
backspacing2452946backspa___cing_
backstabbers2161666backstabber___s
backstabbing2262006backs__tabbing_
backstamping25112206backs__tamping_
backstitching2771536backs_titching_
backstopping2552196backs__topping_
backstories1955316backs___tori_es
backswings2243116backs_____wings
backwaters2195166back_wa_ter___s
bacterins13410646ba___c__terin_s
battering122715146b_____attering_
betattering1444146b___etattering_
blacksmithings2871156blacks_mit_hings
blattering13108716b____lattering_
buccaneering1951536buc__caneering_
chattering16108646__c__hattering_
clattering13109236__c__lattering_
craterings1346006__c__ra_terings
huckstering2152666hucks___tering_
jackhammering346906jack_hammering_
racketeering1951766rack__eteering_
scatteringly1872496____scatteringly
scuttering1386636____scuttering_
shattering1498286____shattering_
smattering1397586____smattering_
spattering13107796____spattering_
wainscottings1961336wainscott__ings

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 Filter178691950240.356501941.0
2DLD Change Limit95024436.87613819.7
3Display Results43430.0301433.3
 (SQL Overall)178691437.26224606.3
 
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.