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

63 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
adamants118634(None) 
adamant101110441adamant_
adamance1345542adamance
adamances1445032adamances
adamancy1643712adamancy
adamantly1543052adamantly
atamans9710432ataman_s
damans94715982_daman_s
abradants1243893abradants
adamancies1543773adamancies
adamantine1353423adamantine
adamsite1144423adamsite
adamsites1243513adamsites
adapts9107813ad__apts
adjoints16103873adjoints
adjutants1772913adjutants
adjuvants2072033adjuvants
adman84517903ad_man__
admass957143ad_ma_ss
admits9411413ad_m_its
advents11309473ad_vents
affiants1445233affiants
agamas97413453agama__s
ailments1039433ailments
alants67722023__alants
aliments10311093aliments
amaranth1355143amaranth
amaranths1443553amaranths
aments85219803__aments
armaments1347473armaments
ataman81013063ataman__
atmans84413963a_tman_s
augments1137833augments
calamints1348053calamints
claimants1344283claimants
clamant11312433clamant_
damages11511283_damages
daman84821163_daman__
damars93815003_dama_rs
damasks1435073_damasks
damianas1155573_damianas
damns84916923_dam_n_s
daunts75014083_da_unts
decants103514443_decants
demands114311413_demands
demasts1089223_demasts
dements103016623_dements
diamante1186423diamante
diamantes1296263diamantes
dopants1038433_dopants
formants13269953formants
galavants1343943galavants
laments94314853_laments
oddments1244103oddments
odorants946043odorants
paraments13511553paraments
peasants1038263peasants
radiants9259443rad_iants
savants1038653_savants
sealants82610743sealants
seawants11337973seawants
shamans123610903shaman_s
siamangs1144063siamangs

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 Limit146162637.20320291.8
3Display Results63630.0134846.2
 (SQL Overall)178691637.62223444.1
 
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.