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

59 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
mandoline124841(None) 
mandolin1148581mandolin_
mandolines1347101mandolines
mandolins1248431mandolins
landline9311442land_line
lanoline8311952lan_oline
amandine1148553amand__ine
aniline7418473_an_iline
bandolier1245283bandolier
candling122313873cand_ling
condoling13510373condoling
dandling112511733dand_ling
gantline9410903gan_tline
gasoline938523ga_soline
handlike1639153hand_like
handling132312713hand_ling
hardline12310273hard_line
induline939493_induline
kaoline11310143ka__oline
landlines1039763land_lines
landslide1184273landslide
lanolin7310643lan_olin_
lanolines939983lan_olines
lanolins8310533lan_olins
macedoine1443553macedo_ine
madeleine1244133ma_deleine
magdalene1352883magdalene
mainline1039863ma_inline
maline84529093ma___line
manacling1446283manacling
mandalic1347803mandali_c
mandarin11411023mandarin_
mandarins12410393mandarins
mandating1339773mandating
mandola1039023mandol__a
mandolas1139133mandol_as
mandolinist1453973mandolinist
mangling122312623man_gling
manhole12311343manhol__e
manlike133012783man__like
mantling112012613man_tling
marline93320973ma__rline
masculine1346443masculine
maudlin1037163maud_lin_
midline102315103m_id_line
moline84422033m___oline
monocline1347793monocline
monokine1448483mon_okine
pangolin1147773pangolin_
pangolins1247373pangolins
parvoline1477173parvoline
randomize2144163randomize
sandaling112010563sandaling
sandlike1339713sand_like
sandling102214413sand_ling
santolina946263santolina
tangolike1453843tangolike
vandalise1347673vandalise
vandalize2246793vandalize

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.423422437.4
2DLD Change Limit148641597.31020333.9
3Display Results59590.0331787.9
 (SQL Overall)178691597.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.