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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
pantoums123671(None) 
pantoum1138701pantoum_
antrums969172_antrums
fantoms12189152fanto_ms
pandours11317992pandours
panicums1444742panicums
pantos85222742panto__s
phantoms1545972phanto_ms
santours837182santours
tantrums1045112tantrums
anthems12309423_anthems
antonyms1345873_antonyms
antrum8611313_antrum_
atoms76817563_a_to_ms
bantams1149063bant_ams
candours11408643candours
canthus1248713canthu_s
cantons95221203canto_ns
cantors94620753canto_rs
cantos84826973canto__s
cantus85117763cant_u_s
centrums1236913centrums
centums11398783cent_ums
contours1039653contours
datums936353da_t_ums
factotums1641923factotums
faitours1134263faitours
fandoms13229473fando_ms
fantasms1345633fantasms
fantods11177623fanto_ds
fantom112110803fanto_m_
fanums1137263fan__ums
handouts1238233handouts
hangouts1236183hangouts
hansoms12238523hanso_ms
madtoms1236923madto_ms
manitous1039173manitou_s
mantrams12288963mantrams
mantuas93410993mant_uas
pablums1345123pa_blums
pabulums1443003pabulums
padouks1434873pa_douks
palliums1236703palliums
pandoors11258983pandoors
pandoras11310053pandoras
pandores11312453pandores
pandour10408213pandou_r
panfuls1237173pan_fuls
pangrams1337153pangrams
panicum1346393panicum_
panthers13510783panthers
panties94230933pant_ies
pantiles103617153pantiles
panto76129413panto___
pantofle1364553pantofle
pantofles1474863pantofles
pantomime1544553pantomime
pantomimes1644233pantomimes
pantries101817393pantries
pants76536923pant___s
pantsuit1046253pantsuit
pantsuits1144083pantsuits
papadums1573853papadums
pappous1057463pappou_s
parlours1036153parlours
parlous9414293parlou_s
parous84024163pa_rou_s
partons94620513parto_ns
pasteups1243493pasteups
pastoriums1445553pastoriums
pastors94119003pasto_rs
patois84319363pa_to_is
paviours1343613paviours
payouts1247303pa_youts
pentodes11310363pentodes
pentoses10312893pentoses
phantasms1643533phantasms
phantom1436693phanto_m_
pintoes95117713pinto_es
pintos86021293pinto__s
pinworms15115783pinworms
pistous92714383pistou_s
planforms1643723planforms
plastrums1344513plastrums
pontons93315553ponto_ns
pontoons10279313pontoons
printouts1143763printouts
protiums1238553protiums
puntos85915793punto__s
putouts937083p_utouts
rancours1076713rancours
randoms102112433rando_ms
ransoms92410163ranso_ms
sanctums1244013sanctums
sanious7514103saniou_s
santims9312603sant_ims
santols73513323santo_ls
santoors837633santoors
santos64421833santo__s
santour737373santou_r
santurs7310763sant_urs
spanworms1643743spanworms
tantalums1143103tantalums
tantrum946683tantrum_
wantons103713013wanto_ns
xanthous1846643xanthou_s

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.423422437.4
2DLD Change Limit1461621067.11020557.2
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.57923577.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.