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

47 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
affraying194310(None) 
arraying1238752a_rraying
defraying1735852defraying
foraying1537432_foraying
fraying143413432__fraying
abrading1239503a_brading
aerating92821003a_erating
affecting1845233affecting
affiancing1941843affiancing
affirming1843103affirming
affixing2264333aff_ixing
affording1744023affording
affray1534973affray___
affrayed1842843affray_ed
affrayer1742693affray_er
affrayers1842213affrayers
affrays1644063affray__s
affricating2043963affricating
affronting1742603affronting
aggrading1344843aggrading
allaying12339313a_llaying
assaying1236003a_ssaying
averaging1446503averaging
betraying1537713betraying
bewraying1834873bewraying
braying134416313__braying
draying123813843__draying
effacing1744463eff_acing
enframing1546113enframing
estraying1338293estraying
faying134521073__f_aying
ferrying15146253_ferrying
flaying143914463__flaying
foraging1358063_foraging
framing133014793__framing
frayings15325993__frayings
frying134511403__fr_ying
graying124115883__graying
hooraying1644783hooraying
hurraying1654323hurraying
panfrying1842993panfr_ying
praying133717323__praying
raying105027193___raying
reframing1538623reframing
refrying15278903refr_ying
spraying14299883_spraying
straying122912693_straying

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 Filter1786911486410.420425454.8
2DLD Change Limit148641475.97024898.0
3Display Results47470.0162937.5
 (SQL Overall)178691476.40627894.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.