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 “maniacal” 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
maniacal124672(None) 
dandiacal1352192dandiacal
magical1239782magi_cal
maniac103917972maniac__
maniacally1744262maniacally
maniacs114313062maniac_s
manioca11358942manioca_
maniocas12298472maniocas
meniscal1246202meniscal
ammoniacal1692073ammoniacal
animal85016253_ani_mal
apical10913903_api_cal
caracal11312513ca_racal
conical11316203coni_cal
cynical1437873cyni_cal
demoniacal1552713demoniacal
egomaniacal1661913egomaniacal
finical1239693fini_cal
heliacal1344723heliacal
laical8312323la_i_cal
lanital7310913lani_tal
magnifical1853103magnifical
manacle11310283man_acle
manana84816073man_ana_
mananas93414733man_anas
mandala10310213mandala_
mandalas1139443mandalas
mandioca1354113mandioca_
mandiocas1443943mandiocas
mania75634153mani__a_
manias84029033mani__as
manic94629443mani_c__
manically16311703manically
manics103919933mani_c_s
manila84518303mani_la_
manilas93915873mani_las
manilla93012473manilla_
manillas102611163manillas
manioc103914823manioc__
maniocs113611443manioc_s
manorial10311083manorial
manpack1746063manpac_k
manual8313463man__ual
manurial1047793manurial
maraca10314153ma_raca_
maracas11313773ma_racas
mariachi1544503mariachi
marital92314183mari_tal
matinal9312603mati_nal
maximal18347093maxi_mal
medical12312513medi_cal
menial84223033meni__al
metical11315363meti_cal
mimical1339233mimi_cal
minicab13177173mini_cab
minicam131110063mini_cam
minicar11109323mini_car
minimal114010603mini_mal
monachal1545703mon_achal
monadal1047893mon_adal
musical1139553musi_cal
radical103312793radi_cal
simoniacal1442163simoniacal
vatical1239983vati_cal
zodiacal2042243zodiacal

Search took 10 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.893200101.9
2DLD Change Limit146162658.61016975.8
3Display Results65650.0135000.0
 (SQL Overall)178691659.51618778.0
 
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.