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

93 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
tantrum94668(None) 
antrum8611311_antrum
tantrums1045111tantrums
antrums969172_antrums
centrum1168602centrum
mantram114011602mantram
pantoum1138702pantoum
tangram1038082tangram
tantalum1044322tantalum
tantra63713362tantr_a
tantras73112092tantras
tantric939592tantric
tantrism1048372tantrism
alarum85411983_alarum
anthem113410343_anthem
antra56521923_antr_a
antral65719413_antral
antre55224523_antr_e
antres65021003_antres
arum66129033_a__rum
asarum84610913_asarum
atrium8411823_a_trium
aurum7614963_a_urum
bantam10314063bant_am
canthus1248713canthus
cantrap113310283cantrap
cantrip112910043cantrip
cantus85117763cant_us
centrums1236913centrums
centum104012363cent_um
chetrum1445343chetrum
datum8310633da_t_um
eardrum10135423eardrum
elytrum1243563elytrum
estrum81810513_estrum
fantasm1236593fantasm
fantom112110803fant_om
fanum10313443fan__um
gantry103810113gantr_y
labarum1166013labarum
labrum1057423la_brum
larum74317973la__rum
lustrum945853lustrum
mantra84116093mantr_a
mantrams12288963mantrams
mantrap11379823mantrap
mantras93815863mantras
mantric11311353mantric
mantua84412023mant_ua
mentum104511713ment_um
natrium948983na_trium
nontrump1243183nontrump
nostrum946953nostrum
oestrum9177783oestrum
pangram1239023pangram
panicum1346393panicum
pantoums1236713pantoums
pantry115014103pantr_y
plastrum1245713plastrum
quantum1845103quant_um
rostrum947223rostrum
sacrum103910143sa_crum
sanctum1145293sanctum
santimu938563santimu
santour737373santour
santur6311273sant_ur
santurs7310763santurs
sistrum946563sistrum
stannum944643stan_num
strum75619453__strum
tactful1236163tactful
talcum1036953ta_lcum
tandem9311413tan_dem
tangrams1136163tangrams
tankful1445163tankful
tanrec837813tan_rec
tantalums1143103tantalums
tantalus836373tantalus
tantara72410823tantara
tantaras8269543tantaras
tantivy1335563tantivy
tanto55724953tant__o
tantrisms1146323tantrisms
tapetum1145393tapetum
tautaug883023tautaug
tectum10328603tect_um
tentorium1146803tentorium
thrum104713633t__hrum
tritium969013tritium
untrim8310683_untrim
untrue6310773_untrue
yantra9449623yantr_a
yantras10259003yantras

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 Filter1786911340270.403443402.0
2DLD Change Limit134027936.67320085.0
3Display Results93930.0332818.2
 (SQL Overall)178691937.10925135.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.