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

63 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
mandolins124843(None) 
mandolin1148581mandolin_
mandoline1248411mandoline
mandolines1347101mandolines
lanolins8310532lan_olins
mandarins12410392mandarins
mandolas1139132mandol_as
mandolinist1453972mandolinist
pangolins1247372pangolins
anilins7416793_an_ilins
bandolier1245283bandolier
bandoliers1344143bandoliers
candling122313873cand_ling
cannolis1037863cannoli_s
condoling13510373condoling
dandelions1243613dandelions
dandling112511733dand_ling
francolins1543873francolins
handling132312713hand_ling
handlings14237343hand_lings
indulins958863_indulins
kaolins1139363ka__olins
landline9311443land_line
landlines1039763land_lines
landslips1284013landslips
lanolin7310643lan_olin_
lanoline8311953lan_oline
lanolines939983lan_olines
magdalens1342833magdalens
magnolias1244723magnolias
manacling1446283manacling
manakins14209763man_akins
mandalas1139443mandal_as
mandalic1347803mandali_c
mandarin11411023mandarin_
mandating1339773mandating
mandola1039023mandol__a
mandolinists1552313mandolinists
mandrills1245453mandrills
mandrils1138493mand_rils
manganins1247123manganins
mangling122312623man_gling
mangolds1235193mangol_ds
manholes13311183manhol_es
manikins14189723man_ikins
mannikins15215093mannikins
mantling112012613man_tling
mantlings12207233man_tlings
manyplies1643893manyplies
marlins93420473ma__rlins
maudlin1037163maud_lin_
monellins1147423monellins
nandins8312003nand__ins
pangolin1147773pangolin_
parvolins1486693parvolins
sandaling112010563sandaling
sandflies1346513sandflies
sandling102214413sand_ling
sandlings11238093sand_lings
santolina946263santolina
santolinas1043753santolinas
santonins948453santonins
vanillins1245543vanillins

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641637.14020818.1
3Display Results63630.0302100.0
 (SQL Overall)178691637.32624391.3
 
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.