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

92 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
affrays164406(None) 
affray1534971affray_
affrayed1842842affrayed
affrayer1742692affrayer
affrayers1842212affrayers
arrays95311682a_rrays
defrays1436112defrays
forays124813002_forays
frays116920102__frays
orfrays1343532orfrays
abfarads1443163abfarads
afars85716513a_f_ars
affair1234353aff_air
affairs1334163affairs
affects1535393affects
affiant1348433affiant
affiants1445233affiants
affines1339483affines
affirms1534383affirms
affixes2035503affixes
afflatus1442683afflatus
affords1435023affords
affraying1943103affraying
affront1357963affront
affronts1444163affronts
afghans1443573afghans
afraid1049723a_fraid
afrits9311903a_frits
agoras7613343agora_s
airways1336243airways
alfas87219043alf_a_s
allays94313743a_llays
always12409133a_lways
amtracs1198883amtracs
anoraks1137603anoraks
anurans73810553anurans
anyways1644423anyways
araks94820883a__raks
arras55626133a_rra_s
array86317143a_rray_
ashrams1236653ashrams
ashtrays14534203ashtrays
assays977903a_ssays
astrals75515243astrals
astray95615543astray_
auras55932553a_ura_s
betrays12127823betrays
bewrays15145113bewrays
brays106723113__brays
defrags1236193defrags
defray1337643defray_
derays105514253_derays
drays95819773__drays
estrays10529403estrays
fairways1743873fairways
farads104713273_farads
farfals13268503farfals
fays108535363__f_ays
ferals94216643_ferals
flays116321053__flays
forams115115913_forams
foray115023973_foray_
frags96322163__frags
fraps105620553__fraps
frass85321123__frass
frats86829673__frats
fray105428903__fray_
furans94515953_furans
grays95621333__grays
hoorays13418373hoorays
hurrays13386153hurrays
maffias15327283maffia_s
morays114613883_morays
ofays11488923_of_ays
offals1235893off_als
offramp1742153offramp
offramps1841653offramps
orfray1234393orfray_
palfreys1642003palfreys
prays105022433__prays
raffias13237713raffia_s
rays77642353___rays
saffrons1444303saffrons
sprays115913643_sprays
strays96417933_strays
sunrays1037083sunrays
taffias13377413taffia_s
taffrail1442353taffrail
taffrails1542063taffrails
trays85623433__trays
zaffars22325233zaff_ars
zaffres22324993zaffr_es

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027925.94022563.5
3Display Results92920.0303066.7
 (SQL Overall)178691926.11029245.7
 
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.