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

140 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
lientery113488(None) 
linter64625342li_nter_
linters73822632li_nters
littery103710492li_ttery
wintery13399752wi_ntery
agentry11165753agent_ry
aliener71011193alien_er_
alieners889823alien_ers
alimentary1553983alimentary
bindery13459833bi_ndery
blistery13418713bli_stery
center84421413_center_
centers94420603_centers
century1237193_century
cindery13429193ci_ndery
clientele1142543clientele
diester83013683diester_
diesters92513603diesters
dietary1158663die_tary
dieter73516773die_ter_
dieters83216433die_ters
dysentery1643043dysentery
eatery95316353__eatery
enter54726383__enter_
entera64216833__entera
enters64425643__enters
entry82414263__ent_ry
finery124512893fi_n_ery
gentry103410443_gent_ry
gingery12368913gi_ngery
glittery12375613gli_ttery
hennery1335303_hennery
hinter94021303hi_nter_
hinters103719583hi_nters
inter55028493_i_nter_
intern64016543_i_ntern
inters64328053_i_nters
jittery17346443ji_ttery
kiester11329973kiester_
kiesters123310153kiesters
lamenter1038863lamenter_
lamenters1137683lamenters
lantern7310013l_antern
leathery14438973l_eathery
lechery15257643l_echery
lectern937033l_ectern
leery85919133l_e__ery
lefter93613433l_efter_
leister73212753leister_
leisters83312823leisters
lender73921273l_ender_
lenders84419643l_enders
lenten6312883l_ente_n
letter63722583l_etter_
letters73819853l_etters
licencer12146143licencer_
licencers13134653licencers
licenser10155883licenser_
licensers11114583licensers
licente91210893licente__
lieder74912323lie_der_
liefer9529573lie_fer_
lienteries1047563lienteries
liever94611863lie_ver_
lifter93814813li_fter_
lifters104313783li_fters
lighter113113443lighter_
lighters123111393lighters
limitary1344933limitary
limiter92710853limiter_
limiters10249333limiters
limner84112873limn_er_
limners93311563limn_ers
lineny94011443li_n_eny
liner55938923li_n_er_
liners65428853li_n_ers
liney87029633li_n_e_y
linger75226003li_nger_
lingers84223303li_ngers
linier64423793li_nier_
linker104321473li_nker_
linkers114317713li_nkers
linsey938993li_nse_y
linted74021823li_nte_d
lintel64013993li_nte_l
lintels73311163li_ntels
lintier73613803li_ntier_
linty87126563li_nt__y
lisente71210703lisente__
lister64527253li_ster_
listers74026533li_sters
liter54736343li__ter_
liters65429883li__ters
litter64324853li_tter_
litters73422573li_tters
livener10278943liven_er_
liveners11217933liven_ers
livery124910903li__very
lottery10389833l_ottery
mesentery1444843mesentery
minter84425103mi_nter_
minters93822473mi_nters
misenter10310833misenter_
misenters1139533misenters
misentry1345773misent_ry
nitery94412173ni__tery
orienter838313orienter_
orienters937623orienters
pinery115214293pi_n_ery
printery13318433printery
reenter73217793reenter_
reenters82915303reenters
reentry1038033reent_ry
reinter73116843reinter_
reinters82614773reinters
renter64527413_renter_
renters74224813_renters
scenery1236563scen_ery
sentry92912053_sent_ry
silenter838873silenter_
sinter63625923si_nter_
sinters74024083si_nters
smeltery13274963smeltery
splintery14264793spli_ntery
tenter64623933_tenter_
tenters73921103_tenters
tindery11389363ti_ndery
tinter63923643ti_nter_
tinters74221113ti_nters
venery123710663_ven_ery
venter94218723_venter_
venters103717733_venters
vinery124912603vi_n_ery
wiener94513543wien_er_
wieners103212483wien_ers
winery125014283wi_n_ery
winter94222803wi_nter_
winterly14306743wi_nterly
winters103720483wi_nters
wintry12498923wi_nt_ry

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.420425454.8
2DLD Change Limit1461621407.18620339.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.65223352.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.