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

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

155 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
foray11502397(None) 
fora75937391fora_
foram105124931foram
forays124813001forays
forby135317671forby
forky156119641forky
forty114824271forty
fray105428901f_ray
moray105423791moray
affray1534972affray
array86317142array
bora66141632bora_
boral75831702boral
boras75938302boras
borax145918722borax
borty105522832borty
bray95232902_bray
copay126516312copay
coral76033452coral
corby125018532corby
corky145221152corky
corny106023272corny
cory96941512cor_y
deray95024182deray
dorky135518742dorky
dormy115817472dormy
dorty96220812dorty
dory85836232dor_y
dray85428092_dray
farad95720672farad
farcy135217092farcy
fay97454862f__ay
feral85424652feral
ferly115517352ferly
ferny115816182ferny
ferry116020802ferry
firry115713532firry
flay106332802f_lay
flora85317102flora_
florae94713882florae
floral94313812floral
floras94715692floras
foal76630922fo_al
foam97127172fo_am
foamy135313202foamy
focal104917672focal
fogey125617872fogey
foggy136714542foggy
fogy115923182fo_gy
foley115222302foley
folky159214712folky
folly115022602folly
footy115820532footy
for66952072for__
forage104617002forage
forams115115912forams
forayed14368592forayed
forayer13368952forayer
forb97131332for_b
forbad122710502forbad
forbs105720802forbs
forbye14427882forbye
force105324272force
ford86835492for_d
fordo97218652fordo
fords95328182fords
fore78351472for_e
forebay1538132forebay
foreby1438632foreby
fores85847102fores
forgat104018582forgat
forge95126942forge
forgo94418332forgo
fork115930942for_k
forks125324682forks
form95836872for_m
formal113215202formal
format113021352format
forme105225992forme
forms105327052forms
formyl14276442formyl
fort76456442for_t
forte86131462forte
forth116222672forth
forts86034452forts
forum108318762forum
forwhy1834422forwhy
foxy176517752fo_xy
foy96044262fo__y
fozy197017162fo_zy
frae75330472f_rae
frag85126272f_rag
frap95925812f_rap
frat75648542f_rat
frays116920102f_rays
fry96226502f_r_y
furan84320012furan
furry116719282furry
fury107727972fur_y
furzy2010116062furzy
goral65125752goral
gorsy95915782gorsy
gory86129662gor_y
gray85329892_gray
hoary114516762hoary
hooray123011372hooray
hora76136562hora_
horah117922052horah
horal86328682horal
horary12310382horary
horas86333102horas
horny115619622horny
horsy116318392horsy
joram145816982joram
kora86431552kora_
korai97018522korai
koras95927112koras
korat94934432korat
loral55927822loral
loran55925092loran
lorry86315672lorry
lory75931712lor_y
mora66641272mora_
morae75831192morae
moral75533432moral
moras76438782moras
morays114613882morays
noway111112842noway
ofay106416102_ofay
okay115917662_okay
ora37250832_ora_
orad56031692_orad
oral47638122_oral
orby97519602_orby
orgy85218002_orgy
porgy116916122porgy
porky145019332porky
porny106020192porny
pray96331532_pray
ray66361992__ray
sora45746912sora_
soras55041012soras
sorry84618252sorry
spray106720062spray
stray88525572stray
today96416952today
tokay125513052tokay
tora47545992tora_
torah87125272torah
toras55540372toras
tory75840542tor_y
tray77632592_tray
wordy126916162wordy
wormy137514252wormy
worry116114332worry

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001551.48636204.6
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.84297009.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.