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

135 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
leisure73669(None) 
leisured934761leisured
leisures836681leisures
seisure738191seisure
censure92310602censure
ensure63416002_ensure
lecture9149522lecture
leister73212752leister
leisurely1242412leisurely
ligure7279472l_igure
measure939032measure
pleasure1045542pleasure
reinsure837912reinsure
seisures838272seisures
seizure1634682seizure
assure6610773_assure
bedsore1057803bedsore
bistre83815023_bistre
ceinture1036313ceinture
censured11248913censured
censurer10228133censurer
censures102211623censures
cesura838763ce_sura
cesurae937703ce_surae
closure9278483closure
coinsure1046933coinsure
demure9311533de_mure
denture8311893denture
desire7415303de_sire
disuse74012843_disuse
endure74014143_endure
ensue54013833_ensu_e
ensured83512943_ensured
ensurer73011903_ensurer
ensures73315903_ensures
enure53520223_e_nure
epicure1136823epicure
erasure736943erasure
failure1035753failure
feature1039853feature
figure10258833_figure
fissure1036783fissure
fixure16256543_fixure
flexure1743413fle_xure
geniture946453geniture
gesture839243gesture
guipure1043533guipure
heister103613623heister
incisure1044563incisure
insure63416603_insure
inure54119053__inure
keister113011573keister
league758743leagu_e
leaguer835793leaguer
lease55230263leas__e
leaser65322673leaser_
leasers74717843leasers
lectured11127233lectured
lecturer10136033lecturer
lectures101310163lectures
legume936913le_gume
leis45739603leis___
leistered1037043leistered
leisters83312823leisters
lemur739773le_mur_
lemures938793le_mures
lemurs837253le_murs
lense54523433lens__e
lessee64116363le_ssee
lesser63514853lesser_
lessor64010603lessor_
lessors73610523lessors
lettuce943323lettuce
lewisite1154543lewisite
licensure1143043licensure
ligule74010833l_igule
ligures8269893l_igures
lire47845293l_i__re
lisle53916723l_is_le
lisper84114433l_isper
listee64223063l_istee
lister64527253l_ister
litre55421463l_i_tre
livre85613253l_i_vre
lure45142463l___ure
lustre64011683l_ustre
measured1136463measured
measurer1035953measurer
measures1038913measures
meister93114163meister
misuse83213643_misuse
moisture1046653moisture
nervure1034973nervure
netsuke1142673netsuke
oversure111611163oversure
pedicure1345183pedicure
peise75825773peis__e
perdure10379623perdure
perjure16327963perjure
pleasured1244193pleasured
pleasures1145573pleasures
pressure1039773pressure
prisere9310943prisere
rasure6311423_rasure
reassure847343reassure
refigure1254693refigure
reinjure1544983reinjure
reinsured1036983reinsured
reinsurer945603reinsurer
reinsures937963reinsures
reissue745873reissue
reissuer854523reissuer
resume8313783re_sume
resurge839073re_surge
scissure1043273scissure
secure8513533se_cure
seise54727853seis__e
seiser65318343seiser_
seisers73816393seisers
seisor63712343seisor_
seisors73212843seisors
seizures1744633seizures
soilure736233soilure
sure45447413___sure
tenure6311613te_nure
texture1497083texture
tonsure758783tonsure
treasure846753treasure
tressure846483tressure
unsure62815413_unsure
veinule1056243veinule
velure939773ve_lure
venture10311173venture
verdure11287773verdure
vesture10310373vesture

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271357.15618729.3
3Display Results1351350.0502700.0
 (SQL Overall)1786911357.60923484.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.