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

47 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
campaigns164347(None) 
campaign1544211campaign_
champaigns2042071champaigns
calpains1239762calpai_ns
campagna1543412campa_gna
campagne1544412campa_gne
campaigned1842152campaigned
campaigner1751952campaigner
campaigners1851872campaigners
campings154010202camp_ings
campions143511292camp_ions
champaign1942472champaign_
arraigns944353_arraigns
calpain11310413calpai_n_
camails11311753cam_ai_ls
camions113916133cam__ions
campaigning1952003campaigning
campaniles1644113campaniles
campfires1844123campfires
camphine1738373camphi_ne
camphines1847563camphines
camphires1845783camphires
camping143118973camp_i_ng
campion133011413camp_ion_
campongs15356123campong_s
campsites1546473campsites
caplins113515993ca_pli_ns
cappings15369493ca_ppings
captains121810573captai_ns
captions123813223ca_ptions
carpings133812393carp_ings
champagne1942783champa_gne
champagnes2042673champa_gnes
champions18875783champ_ions
companions1697263companions
complains1549193complai_ns
complins14313113compli_ns
dampings14377523damp_ings
lampions12277973lamp_ions
papains11312363pa_pai_ns
rampages1336673rampa_ges
rampaging1544513rampaging
rampions12248023ramp_ions
sampans112411003sampa__ns
samplings1435553samplings
tampans113310983tampa__ns
tampions12358123tamp_ions

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.453394461.4
2DLD Change Limit148641477.26620457.1
3Display Results47470.0162937.5
 (SQL Overall)178691477.73523101.6
 
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.