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 “affray” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

162 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
affray153497(None) 
affrays1644061affrays
affrayed1842842affrayed
affrayer1742692affrayer
array86317142a_rray
astray95615542astray
defray1337642defray
foray115023972_foray
fray105428902__fray
orfray1234392orfray
abfarad1344223abfarad
aboral8314373aboral
aery77231683a_er_y
afar76720783a_f_ar
afars85716513afar_s
afeard1058263afeard
aff95537613aff___
affably1855183affably
affair1234353affair
affect1448903affect
affiant1348433affiant
affinal1336443affinal
affine12310503affine
affirm1435523affirm
affirms1534383affirms
affix1836003aff_ix
affixal2043763affixal
afflux1942793afflux
afford1346493afford
affords1435023affords
affrayers1842213affrayers
affraying1943103affraying
affront1357963affront
afghan1333873afghan
afire86215913afir_e
afloat9315153afloat
afore85818603afor_e
afraid1049723a_fraid
afrit8323173a_frit
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
airway1237693airway
airy75734153a_ir_y
alary86123443alar_y
alfa77624273alf_a_
alfas87219043alf_as
allay85620393a_llay
alway116113923a_lway
ambary134010543ambary
ambry123512103ambr_y
amoral8314633amoral
amtrac10109123amtrac
anergy10156863anergy
angary10311323angary
angry9310863angr_y
anorak1038923anorak
antra56521923antra_
antral65719413antral
anural65714743anural
anuran64313243anuran
anyway1534803anyway
apery106517903aper_y
apiary113910383apiary
arak86929573a__rak
ariary94114203ariary
army96624183a__rmy
arras55626133a_rras
arrays95311683a_rrays
arty77531313a__rty
ashram1139053ashram
ashtray13805553ashtray
assay8710283a_ssay
astral66919283astral
ataraxy1743983ataraxy
aura45836253a_ura_
aurae54128113a_urae
aural54428963a_ural
aurar54420253a_urar
auras55932563a_uras
aviary12338413aviary
away108024223a__way
aweary1237303aweary
awry107619683a_wr_y
baffy165511923baff__y
betray111511443betray
bewray14147733bewray
bray95232903__bray
daffily1735133daffily
daffy155510283daff__y
defrag1136463defrag
defrays1436113defrays
deray95024183_deray
dray85428093__dray
effigy1642213effigy
estray95713333estray
faery116015483faer_y
fairly125610013fairly
fairway1644333fairway
fairy115318283fair_y
farad95720673_farad
farcy135217093_farcy
farfal123410183farfal
fay97454863__f_ay
feral85424653_feral
ferly115517353_ferly
ferny115816183_ferny
ferry116020803_ferry
firry115713533_firry
flay106332803__flay
fora75937393_fora_
foram105124933_foram
forays124813003_forays
forby135317673_forby
forky156119643_forky
forty114824273_forty
frae75330473__frae
frag85126273__frag
frap95925813__frap
frat75648543__frat
frays116920103__frays
fry96226503__fr_y
furan84320013_furan
furry116719283_furry
fury107727973_fur_y
furzy2010116063_furzy
gray85329893__gray
halfway1943763halfway
hooray123011373hooray
hurray12459913hurray
iffy135312283iff__y
infra838643infra_
maffia14327203maffia_
maffias15327283maffias
moray105423793_moray
ofay106416103_of_ay
offal1136243off_al
offkey1932343offkey
offramp1742153offramp
orfrays1343533orfrays
palfrey1533343palfrey
panfry14456413panfr_y
pray96331533__pray
raffia12287703raffia_
raffias13237713raffias
ray66361993___ray
refry114412463refr_y
saffron1344173saffron
spray106720063_spray
stray88525573_stray
sunray9310123sunray
taffia12286903taffia_
taffias13377413taffias
taffrail1442353taffrail
taffy145110823taff__y
tray77632593__tray
wafery15398693wafer_y
waffly18305433waff_ly
zaffar21385043zaff_ar
zaffars22325233zaffars
zaffre21354663zaffr_e
zaffres22324993zaffres

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161625.50020493.8
3Display Results1621620.0463521.7
 (SQL Overall)1786911625.92230174.1
 
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.