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

62 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
ointment106923(None) 
ointments1166651ointments
anointment1256462anointment
fitment12710302fi_tment
intent63122772_int_ent
liniment1049532liniment
ornament1049132ornament
pointmen1245422pointmen_
abetment1248233abetment
abutment1247223abutment
ailment9314233ai_lment
alinement1149103alinement
anointments1355433anointments
appointment1753493appointment
coinvent1348183coin_vent
content94326153cont_ent
diriment11410743diriment
distent84120853dist_ent
eloinment1147253eloin_ment
figment1379743fi_gment
filament13410033filament
fitments1376793fi_tments
hitmen11239193hi_tmen_
hutment1239173_hutment
incent83320723_in_cent
indent73021243_in_dent
intend72310373_int_end
intents72115703_int_ents
interment11419223_interment
intrant7318753_intrant
intreat7416303_intreat
invent93316363_in_vent
kinsmen1335653kinsmen_
liftmen1234233liftmen_
ligament1149313ligament
lineament1147843lineament
linemen938633linemen_
liniments1146613liniments
linkmen1335363linkmen_
lintiest82715913lintiest
mintiest103217143mintiest
monument1289903monument
muniment1248943muniment
oddment1145923o_ddment
oilmen848313oi_lmen_
oinomel946353oinome_l
oinomels1044513oinomels
ornaments1146633ornaments
orpiment1247973orpiment
outwent10311363o_utwent
pigment12510733pi_gment
pitmen102510793pi_tmen_
pointiest1139623pointiest
pointman1244803pointman_
ringent8315153rin_gent
sentient8313633sentient
sentiment11410723sentiment
tenement10412593tenement
tinmen82310403tin_men_
titmen8239883ti_tmen_
vestment13109203vestment
wingmen1336113wingmen_

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.436409841.7
2DLD Change Limit146162626.95321021.4
3Display Results62620.0331878.8
 (SQL Overall)178691627.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.