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

126 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
pleiades114575(None) 
pleiads1045221pleiad_s
pesades10310902p_esades
pleaded113511262ple_aded
pleader103511752ple_ader
pleaders113210182ple_aders
pleads94613952ple_ad_s
pleases94515482ple_ases
pleiad947832pleiad__
prefades1439532prefades
alcades101011473al_cades
alcaides11117673alcaides
aliases7914493al_iases
alidades1037003alidades
blades95221253bl__ades
blendes104713683ble_ndes
clades94920463cl__ades
cleaves124111623cle_aves
decades113615513_decades
elevates111110423elevates
elides74420693el_i_des
evades1039023__evades
glades84820343gl__ades
gledes84915133gle__des
glides84518863gl_i_des
grenades1038433grenades
hexades18378703_hexades
ileitides1045613ileitides
iliads7448673il_iad_s
lades65141273_l__ades
leaded84221543_le_aded
leaden74515223_le_aden
leadens83610983_le_adens
leader74824653_le_ader
leaders83819603_le_aders
leads66028493_le_ad_s
leases65428113_le_ases
leaves94222383_le_aves
legates82917683_legates
leudes75314093_le_udes
lianes63819323_l_ianes
maenades1137473maenades
naiades838213_naiades
oleates7417833ole_ates
oleines7313393olei_nes
oreides8312023orei_des
palefaces1645303palefaces
palisades1245613palisades
palliates11311033palliates
parades104121463p_arades
parkades1538273parkades
passades1139203passades
peaces106324083p_e_aces
peages94321853p_e_ages
peases85229473p_e_ases
pedes85327293p_e__des
peerages1189893peerages
peises84125043p_ei_ses
pelages10714613p_elages
pelisses1048483pelisses
pelites93821993peli_tes
penates93321603p_enates
pervades1437353pervades
pesade9311103p_esade_
phenates13611573phenates
placates12311753placates
places104323703pl__aces
plages94520153pl__ages
plaices11411143plai_ces
plaided11409643plai_ded
plaids94312443plai_d_s
planes85028083pl__anes
platanes102711883platanes
plates85432243pl__ates
pleaches153210433pleaches
plead85818463ple_ad__
pleas75627033ple_a__s
please84315733ple_ase_
pleased103712073ple_ased
pleaser93912343ple_aser
pleasers104010293ple_asers
pleated103816633ple_ated
pleater93916333ple_ater
pleaters103613793ple_aters
pleats85218593ple_a_ts
plebes104313623ple__bes
pledgees12376283pledgees
pledges113811583ple_dges
plenaries11410383plenaries
plenches153110623plenches
plenishes1487083plenishes
plenitudes1343123plenitudes
plenties10314693plenties
plexes155313543ple__xes
plexuses1734113plexuses
plies74526513pl_i__es
plisses94411773pl_isses
ploidies1138173ploidies
plumages1335653plumages
poleaxes1767273pole_axes
pomades123711733p_omades
prebade12310283prebade_
prebakes1639013prebakes
precedes13310713precedes
precodes13711573precodes
predates11615813predates
prefaces15311063prefaces
prefade1339013prefade_
prefaded1537823prefaded
pregames1339003pregames
prelates10418573prelates
preludes1137833preludes
premade12311443premade_
prenames12311643prenames
prepares122014163prepares
prepaves15189193prepaves
presages11312203presages
presales10315263presales
presides11414913presides
pretapes122811533pretapes
prides94324183p_ri_des
pyxides2034423pyxi_des
sleaves103813203sle_aves
sleazes162810333sle_azes
slides73922183sl_i_des
ureides8311103urei_des

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621267.43619656.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.88822653.5
 
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.