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

87 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
alienness94537(None) 
alienees8118652alie_nees
alieners889822alie_ners
aliennesses1145862aliennesses
alikeness1336332alikeness
aliveness1238222aliveness
aloneness957312aloneness
acidness1136723aci_dness
agedness1036683a_gedness
agileness1046493agileness
aginners954623agi_nners
airiness8412213a_iriness
alertness946053alertness
algidness1144273algidness
alienages1045973alienages
alienates9310683alienates
aliened81011743alie_ne_d
alienee71013153alie_ne_e
aliener71011193alie_ne_r
alienism1047733alie_nism
alienisms1146703alienisms
alienist8411993alie_nist
alienists946913alienists
alienors8136733alie_nors
aliens65619213alie_n__s
aligners9117573ali_gners
aliners74717723ali__ners
alines65735223ali__ne_s
alkenes114212753alke_ne_s
aloofness1242493aloofness
ancientness1353353ancientness
apishness1445743apishness
aridness939223ari_dness
askewness1642043askewness
avidness1246113avi_dness
barrenness1243753barrenness
blindness1235343blindness
blueness1038213blue_ness
briefness1444113briefness
cleanness1144973cleanness
clientless1272493clientless
drivenness1443463drivenness
evenness1135543_evenness
falseness1236093false_ness
fineness11310643_fineness
fleetness1244753fleetness
glegness1034613gl_egness
glibness1134133gli_bness
glueyness1342913glueyness
goldenness1243413goldenness
greenness1046793greenness
haleness11312623hal_e_ness
juliennes1642343julienne_s
keenness1234883_keenness
lameness102612673lame_ness
lateness82614073late_ness
leanness837373_leanness
liernes739623_lierne_s
likeness12229863_likeness
liminess10510643_liminess
limpness1246703_limpness
lineless82711943_lineless
linnets739833_li_nnets
lioness739103_li_oness
liteness82213213_liteness
liveness112411393_liveness
loneness8512093_loneness
lornness836493_lornness
maleness10312313mal_e_ness
openness1035473_openness
paleness10312983pal_e_ness
plainness1155183plainness
planeness1138153planeness
pliantness1263643pliantness
quietness1844753quietness
saliences11108063salience_s
silentness1044573silentness
sleekness1344543sleekness
slickness1535903slickness
sliminess1137423sliminess
slimness1036523sli_mness
sullenness1054153sullenness
thinness11277163thi_nness
vainness1136063vai_nness
valiantness1452313valiantness
validness13125363vali_dness
vileness1139983vile_ness

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.420425454.8
2DLD Change Limit148641877.45319943.8
3Display Results87870.0461891.3
 (SQL Overall)178691877.91922564.8
 
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.