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

65 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
panicums144474(None) 
panicum1346391panicum_
panicles121010112panicles
panics103815362panic__s
pantoums1236712pantoums
amicus103810003_amicu_s
animus84211613_animu_s
antrums969173_antrums
bariums1139143bari_ums
calciums1446163calciums
capsicums1742383capsicums
coniums11311863coni_ums
craniums1297913crani_ums
fanums1137263fan__ums
franciums1644413franciums
hafniums1643103hafni_ums
hahniums1643343hahni_ums
ioniums938303ioni_ums
kaliums1336603kali_ums
manics103919933manic__s
manicure1245803manicure
manicures1346263manicures
manitus9310923manitu_s
maximums1842813maximums
minicams14126873minicams
minimums11404603minimums
miniums113910223mini_ums
modicums1543483modicums
nanisms938833nani_sms
pablums1345123pa_blums
pabulums1443003pabulums
painches1588913painches
palliums1236703palliums
panaceas1236763panaceas
panaches15310283panaches
pandours11317993pandours
panfuls1237173pan_fuls
pangrams1337153pangrams
panic93923903panic___
panicked1785173panicked
panicky1833853panic_ky
panicle11129983panic_le
panicled13106783panicled
paniers94717333pani_ers
panochas1545653panochas
panoches1548123panoches
pantoum1138703pantoum_
papadums1573853papadums
papisms13238543papi_sms
paviours1343613paviours
paynims1434973payni__ms
penicils1247863penicils
pianisms1249013piani_sms
piculs103511753p__iculs
platinums1343963platinums
podiums12227633podi_ums
practicums18132753practicums
radiums10299313radi_ums
sanctums1244013sanctums
sanicles10149943sanicles
sanious7514103saniou_s
talcums1135513ta_lcums
tantrums1045113tantrums
uraniums10117163urani_ums
viaticums1642173viaticums

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 Limit146162656.89021213.6
3Display Results65650.0331969.7
 (SQL Overall)178691657.34624324.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.