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

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

86 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
afore8581860(None) 
adore65723671adore
afire86215911afire
fore78351471_fore
abode85518812abode
abort76133582abort
above105414322above
acorn75616622acorn
acre67330772a_cre
adobe84814712adobe
adored84714242adored
adorer74713452adorer
adores74420722adores
adorn64917092adorn
adoze155713832adoze
afar76720782afar_
afars85716512afars
afford1346492afford
afoot8420112afoot
afoul8510192afoul
after85719792after
agone65924552agone
agora6914332agora
agorae7511202agorae
ahorse9311512ahorse
aloe45540192alo_e
alone55732962alone
amole75724592amole
amort75832202amort
anode65021032anode
anole55330372anole
antre55224522antre
aport75432172aport
are37874572a__re
arose55832082arose
ashore9414612ashore
atone56527982atone
aware86420022aware
awoke124912002awoke
axone125918472axone
azole145118032azole
azote144416342azote
azure14911482azure
before11410152before
bore66051332_bore
chore105126762chore
core67263112_core
crore74922862crore
dore56353302_dore
fare76354462_fare
fere76342232_fere
fire76245592_fire
foe66350812_fo_e
for66952072_for_
fora75937392_fora
forb97131332_forb
force105324272_force
ford86835492_ford
fores85847102_fores
forge95126942_forge
fork115930942_fork
form95836872_form
forme105225992_forme
fort76456442_fort
forte86131462_forte
froe75329992_froe
frore86218802frore
galore73514852galore
gore55744962_gore
kore85834162_kore
lore45850352_lore
more67154522_more
ore36661832__ore
pore66451262_pore
score75526732score
shore85432652shore
snore55424952snore
sore47059532_sore
spore75428592spore
store56333812store
swore84920812swore
tore47359322_tore
whore116018042whore
wore77144672_wore
yore76335942_yore
zaffre21354662zaffre

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.0931921408.6
2DLD Change Limit53800861.45337026.8
3Display Results86860.0165375.0
 (SQL Overall)178691861.562114398.8
 
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.