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

96 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
paean7722272(None) 
paeans85118261paeans
paeon74819491paeon
paesan85114091paesan
pagan86121161pagan
pavan106518471pavan
pean66147171p_ean
aeon45634612_aeon
alan46844082_alan
apeak115513452apeak
apian75018332apian
azan136521782_azan
bean66443862_bean
clean75420412clean
daman84821162daman
dean56039482_dean
faena85014202faena
gaen57329602gae_n
glean65818202glean
haen76229452hae_n
hazan173813612hazan
japan14411232japan
jawan15710382jawan
jean116629282_jean
lagan66520342lagan
lauan55216792lauan
lean46345242_lean
mayan105616902mayan
mean65538092_mean
naan47621932na_an
ocean71212962ocean
paca85132242paca_
pacas96029402pacas
paeons83915522paeons
paesani9348682paesani
paesano9338792paesano
paesans93312692paesans
pagans95717922pagans
pageant10312782pageant
pain65647242pa_in
paisan84417072paisan
palea75028662palea_
paleae84820292paleae
paleal84716672paleal
pampean1335542pampean
pan58466452p__an
papa85827142papa_
papain10313792papain
papal95820672papal
papas94927492papas
papaw125112492papaw
para65242172para_
parae76335702parae
parang93715512parang
paras76143042paras
parian83223962parian
partan83820562partan
paten74827342paten
patin76832852patin
pavane114113442pavane
pavans115715592pavans
pavin105623202pavin
pawn94625302pa_wn
pea56657242p_ea_
peag75431342p_eag
peak106535202p_eak
peal68648102p_eal
peans75437642p_eans
pear69745232p_ear
peas65755062p_eas
peat65967932p_eat
pecan91919032pecan
peen65938082p_een
pein65834942p_ein
pekan111613972pekan
pen56558842p_e_n
peon65635242p_eon
pian66136092p_ian
plan65833942p_lan
platan83913692platan
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
plena75816392plena
pleon74216382pleon
preen75925052preen
preman104117452preman
pyran10514472pyran
quean143612842quean
ratan53722662ratan
saran53730302saran
skean94415622skean
spean74620512spean
wean75734352_wean
yean75834582_yean

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.296603685.8
2DLD Change Limit53800961.48336277.8
3Display Results96960.0332909.1
 (SQL Overall)178691961.81298615.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.