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

96 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
malarky164543(None) 
malarkey1743401malarkey
alary86123442_alar_y
larky125218872__larky
malady1237862mala_dy
malar76424442malar__
malaria9313692malaria
malarkeys1841962malarkeys
malars85020682malar_s
salary9515212salar_y
alack114820063_alack_
alar46340073_alar__
alarm76621423_alar_m
alarms85913053_alarms
alarum85411983_alarum
alaska1036713_alaska
alky115920343_al__ky
ambary134010543ambar_y
autarky1444703autarky
balky145418243bal__ky
barky145721613__barky
calory11312843calor_y
calvary1537183calvar_y
canary11314693canar_y
clanky15469073_clanky
clary105719613_clar_y
darky136018833__darky
datary10310243datar_y
flaky155715583_fla_ky
galaxy17476313gala_xy
glary96018543_glar_y
kolacky1543203kolacky
laky116725823__la_ky
lanky125517483__lanky
lardy96119273__lardy
lark85733863__lark_
larks95227813__larks
maar66025063ma_ar__
maars74621633ma_ar_s
majorly1943153majorly
makar115614973makar__
makars124612633makar_s
malacca1344953malacca
malaise9312673malaise
malanga1036663malanga
malaprop1443073malaprop
malarial10410613malarial
malarian10311563malarian
malarias10313773malarias
malarkies1545113malarkies
malaroma1245583malaroma
malate84624553mala_te
malates93522603malates
malgre9299303malgr_e
mallard10310273mallar_d
mallards1138323mallards
malmsey1433623malmsey
malmy124816343mal__my
malty106721703mal__ty
mammary1335993mammar_y
manuary1237773manuar_y
mark105138063m__ark_
marka114620793m__arka
marks115933483m__arks
marly106925613m__arly
marry104821693m__arry
marvy135014033m__arvy
mazard1838763mazar_d
mazards1937703mazards
mazurka2272873mazurka
milady1236613mila_dy
miliary1249463miliar_y
milky144014443mil__ky
mirky146315523m__irky
molar75223093molar__
molarity13118903molarity
molars85517323molar_s
mudlark1463913mudlark_
mudlarks1542883mudlarks
murky145216683m__urky
mylar105311533mylar__
mylars114310443mylar_s
narky126017803__narky
palfrey1533343palfrey
palmary14338553palmar_y
paltry114910403paltr_y
salably121610743salably
sarky125521783__sarky
snarky134210843_snarky
sparky154511523_sparky
talar56225383talar__
talaria7412513talaria
talars66021683talar_s
talcky15294723tal_cky
talky126215683tal__ky
vagary1337333vagar_y

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.1561145455.1
2DLD Change Limit134027966.89019452.4
3Display Results96960.0303200.0
 (SQL Overall)178691967.07625253.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.