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

55 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
pangolins124737(None) 
pangolin1147771pangolin_
lanolins8310532lan_olins
mandolins1248432mandolins
parvolins1486692parvolins
angeling102811733_angeling
angling92816043_ang_ling
anglings10228273_ang_lings
anilins7416793_an_ilins
cannolis1037863cannoli_s
dangling112611233dang_ling
francolins1543873francolins
gangling112411403gang_ling
ganglions1144063gang_lions
jangling17249623jang_ling
kaolins1139363ka__olins
lanolin7310643lan_olin_
lanoline8311953lan_oline
lanolines939983lan_olines
magnolias1244723magnolias
mandolin1148583mandolin_
mandoline1248413mandoline
mandolines1347103mandolines
manganins1247123manganins
mangling122312623mang_ling
mangolds1235193mangol_ds
paneling111013623pan_eling
panelings12107453pan_elings
panelling1239073panelling
panellings1344533panellings
pangens103112063pang__ens
panging113319113pang__ing
pannikins15204843pannikins
panoplies1346003panoplies
pargyline1544653pargyline
pargylines1643833pargylines
paroling113316213pa_roling
parvolin1376933parvolin_
parvoline1477173parvoline
parvolines1585993parvolines
paulins9312613pa__ulins
penguins1145383peng_uins
picolins1239853p_icolins
pignolias1243723pignolias
pignolis1146053pignoli_s
pungling12228663pung_ling
santolina946263santolina
santolinas1043753santolinas
santonins948453santonins
spangling1336373spang_ling
tangling101712543tang_ling
tangoing10177893tango_ing
tangolike1453843tangolike
vanillins1245553vanillins
wangling132310993wang_ling

Search took 7 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.436409841.7
2DLD Change Limit148641556.28023668.9
3Display Results55550.0163437.5
 (SQL Overall)178691556.73226543.5
 
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.