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 “alienated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
alienated104774(None) 
alienate8311551alienate_
alienates9310681alienates
acierated1238282acierated
alienage945582alienage_
alienages1045972alienages
alienator946192alienator
aliened81011742alien__ed
alimented1245312alimen_ted
alternated1145722alternated
lineated9711062_lineated
unalienated1244012unalienated
abnegated1344163abnegated
absented1156613absen_ted
accented13107773accen_ted
acerated113113983a_cerated
acetated112010683a_cetated
acierate10311813acierate_
acierates11310813acierates
aerated85322373a__erated
agented939423a_gen_ted
agitated1038413agi_tated
alated75625143al___ated
alerted82512223al_e_rted
alginate9310693alginate_
alginates10310123alginates
alienable1146933alienable
alienating1147223alienating
alienation1048793alienation
alienators1045783alienators
alienee71013153alien__ee
alienees8118653alien_ees
aliener71011193alien__er
alighted1347673ali_ghted
aligned9128553align__ed
alined75221403ali_n__ed
aliterate91611333aliterate_
aliterates101510753aliterates
alkylated1753483alkylated
alleviated1443963alleviated
alliterated1294693alliterated
allocated1248093allocated
altercated1345453altercated
alternate948113alternate_
alternates1047873alternates
animated111612373ani_mated
antedated1146703antedated
arsenate81010483arsenate_
arsenates979373arsenates
asperated1239313asperated
assented957513assen_ted
attenuated1183203attenuated
aviated11310263avi__ated
bleated104015973bl_e_ated
calibrated1545643calibrated
carinated123414263cari_nated
catenated1238913catenated
cleated103417843cl_e_ated
crenated113013913_crenated
delineated1246243delineated
elevated12118293el_evated
eliminated1345953eliminated
flinted114411893fli_n_ted
galeated104111573gal_e_ated
galivanted1542553galivanted
glinted9399373gli_n_ted
halogenated1653453halogenated
italianated1251863italianated
lacerated122210673lacerated
lamented1138193lamen_ted
laminated122610283laminated
lanated8313203_l_anated
legated92513983_l_egated
lenited8812433_l_enited
liberated1299473_liberated
librated113110313_librated
ligated92414143_li_gated
lineate7815153_lineate_
linted74021823_li_n_ted
liquated1835493_liquated
lunated8310823_l_unated
marinated122513173mari_nated
orientated1144853orientated
oriented937483orien_ted
paginated13309463pagi_nated
patinated123911413pati_nated
pileated112711133pile_ated
pinnated11338553_pinnated
pleated103816633pl_e_ated
plicated13310643pli_cated
pollenated1345013pollenated
ruinated939523rui_nated
salivated1337473sali_vated
talented938423tal_en_ted
ulcerated1247743ulcerated
urinated9311613uri_nated
vaginated14328153vagi_nated
validated1446493vali_dated
variegated1543113variegated
venenated1345903venenated

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411007.21620598.8
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.70223200.6
 
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.