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

116 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
unguent83912(None) 
unguenta943711unguenta
unguents945151unguents
pungent10311232pung_ent
unbent83216592un_bent
unburnt977412unburnt
unguentum1252112unguentum
ungues7412122ungue_s
unkent103116052un_kent
unpent83117372un_pent
unrent63219782un_rent
unsent63820962un_sent
unspent92610892unspent
urgent73816042urg_ent
abluent939623abluent
agent65829643_ag_ent
ancient9514733ancient
anent54931843an__ent
anguine839913anguine
argent74023663arg_ent
argument1158903argument
augment10910203augment
baguet9316103bague_t
cogent9321003cog_ent
congruent1247413congruent
diluent8310263diluent
dungiest102810743dungiest
eluent6315483_eluent
figment1379743figment
fluent9313933_fluent
fulgent1138903fulg_ent
gent56954393__g_ent
guest65225923__guest
incent83320723in_cent
indent73021243in_dent
influent1147623influent
ingest73119003ing_est
inquest1638603inquest
intent63122773in_tent
invent93316363in_vent
judgment1944033judgment
languet8713693langue_t
muniment1248943muniment
nocent83217413_nocent
nonguest938563nonguest
nugget8311723nugge_t
pigment12510733pigment
regent74127673reg_ent
ringent8315153ring_ent
segment10312563segment
sequent16410323sequent
sunburnt1045603sunburnt
tangent8314993tang_ent
tegument1177523tegument
turgent8712393turg_ent
unadept1046603unadept
unbelt83015693un_belt
unbend9269773un_bend
unblest9411813unblest
unbuilt948003unbuilt
uncleft1257493uncleft
uncurrent1145673uncurrent
uncut73219173uncu__t
undrest8313013undrest
undue66715553undue__
undulant946823undulant
uneven957913uneven_
unfelt92413463un_felt
unfunny1343073unfunny
ungentle946573ung_entle
ungently1256953ung_ently
ungirt71112713ung_irt
unglue748003unglue__
unglued937303unglue_d
unglues836993unglue_s
ungluing1035863ungluing
ungot61718063ung__ot
ungual738183ungu_al
unguard955093unguard
unguis738453ungu_is
ungula737603ungu_la
ungulae837313ungulae
ungular836773ungular
ungulate939803ungulate
unhung1035283unhu_ng
unhurt9311253unhu_rt
uniquest1775603uniquest
unjoint1449233unjoint
unjust1337873unju_st
unkend11309223un_kend
unkept123710873un_kept
unlet54133333un_le_t
unmeant9510903unmeant
unmeet83815743un_meet
unmet74426393un_me_t
unopen838913unopen_
unpen72913573un_pen_
unpens82511013un_pens
unquiet16310663unquiet
unrest62918853un_rest
unseat64221023un_seat
unseen62012623unseen_
unset54532433un_se_t
unsilent849603unsilent
unsung736983unsu_ng
unsunk1036333unsu_nk
unswept1246013unswept
untruest847783untruest
untune62511603untu_ne
untuned82010823untuned
untunes72211253untunes
unvext1658173un_vext
unwept11389813un_wept
unwet84423173un_we_t
upsent83314063u_psent
vaguest1137333vaguest

Search took 7 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.420425454.8
2DLD Change Limit1340271165.94022563.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.40627894.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.