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

106 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
plangent113880(None) 
pangen94115922p_angen_
pangene102711962p_angene
pangens103112062p_angens
planet84228352plan_e_t
plangency1742802plangency
plangently1653582plangently
pungent10311232p_ungent
tangent8315002_tangent
agent65829643__a_gent
anent54931843__an_ent
argent74023663__argent
blandest113811043blandest
blankest14439063blankest
blanket134313093blanke_t
candent10417363_candent
clanged114212653clange_d
clanger104113493clange_r
clangers114312343clangers
clanging124012123clanging
coagent10313983coa_gent
cotangent1246833cotangent
flange103411973flange__
flanged123810843flange_d
flanger113412623flange_r
flangers123311373flangers
flanges113413273flange_s
flanging132710583flanging
flanken14226763flanken_
lagend838743_la_gend
lambent113711303_lambent
lament85024943_la_ment
lancet84223573_lance_t
languet8713693_languet
lankest112714113_lankest
largest83715103_largest
latent64124303_la_tent
lenient7313843_lenient
lilangeni1051483lilangeni
longest84114953_longest
margent10316693_margent
pageant10312783p_a_geant
pandect12310953p_andect
panged104722343p_ange_d
pangenes112612823p_angenes
panging113319113p_anging
parent83230423p_a_rent
parget94529393p_arge_t
patent84524923p_a_tent
patient9617073p_atient
payment14310703p_ayment
pendent10314723p_endent
placement1548183placement
placenta1275723pla_centa
placet103923673pla_ce_t
placket15412873placke_t
plage84520403pla_ge__
plages94520153pla_ge_s
plainest10313613plainest
plaint85323203pla__int
plaintext1863423plaintext
planchet152511963planchet
plane74929143plan_e__
planed94420913plan_e_d
planer84122653plan_e_r
planers94517943plan_ers
planes85028083plan_e_s
planets93914083plan_ets
planing103418253plan_ing
planked143512283planke_d
planking153513013planking
planless1036813planless
planned103810153planne_d
planner93511623planne_r
planners10399933planners
planning113610223planning
plant75437113pla___nt
planted103516123plante_d
planter94017803plante_r
planters102915323planters
planting113515383planting
plantlet10310013plantlet
platen84518203pla_ten_
platens94213983pla_tens
platiest103216093platiest
playlet1239523playle_t
playpen1434693playpen_
playpens1534073playpens
pledget113510653pledge_t
plunge93811053plunge__
plunged11439523plunge_d
plunger104211243plunge_r
plungers11379403plungers
plunges104011613plunge_s
plunging12357673plunging
ponent82821593p_on_ent
pranged114512553prange_d
pranging123012723pranging
reagent8716603rea_gent
ringent8315153_ringent
scandent1148493scandent
slanged94112853slange_d
slangiest10129083slangiest
slanging103413433slanging
splendent1246073splendent
tangents938713_tangents

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 Limit1461621066.98620922.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.42224075.9
 
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.