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 “finmarks” 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
finmarks1715447(None) 
finmark16154881finmark_
finnmarks18122051finnmarks
finbacks1965362finbacks
finnmark17122342finnmark_
mismarks1645892mismarks
airparks1443913airparks
demarks14339233_demarks
dinars75417563din_ar_s
earmarks1444793earmarks
fanfares1436773fanfares
fiars86720833fi__ar_s
filmcards1742473filmcards
filmers124211293filmer_s
finales104016013fin_ales
finalis103313663fin_alis
finals94316163fin_a_ls
finback1865823finback_
fincas113512073finca__s
finders113717873finder_s
fingers113418433finger_s
finials103210153finia_ls
finks125424223fin___ks
firearms1335403firearms
firmans12238523firma_ns
firmers124711443firmer_s
firmwares1743853firmwares
footmarks1843583footmarks
fulmars1246423fulmar_s
futharks1843783futharks
imbarks15326613_imbarks
imparks15276663_imparks
inarms8410093_in_arms
infares10313023_infares
inmates92715783_inmates
innards837153_innards
invars9310003_invar_s
inwards1138343_inwards
kinaras1159123kin_aras
landmarks1643613landmarks
marks115933483___marks
miniparks1742943miniparks
mismark1536703mismark_
narks96026033__n_arks
ninebarks1543683ninebarks
ostmarks1443893ostmarks
pinworks17106353pinworks
pugmarks1742533pugmarks
qindarka2241923qindarka
qindars17267423qindar_s
qintars16268573qintar_s
remarks13329983_remarks
ringbarks1643483ringbarks
seamarks1445303seamarks
simars84916933si_mar_s
sitzmarks2441583sitzmarks
snarks104815733_sn_arks
tanbarks1445563tanbarks
tidemarks1643073tidemarks
tinwares1137913tinwares
tinworks1596043tinworks
titlarks1243693titlarks
unmasks1344553_unmasks

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 Filter1786911461620.420425454.8
2DLD Change Limit146162636.34623032.1
3Display Results63630.0302100.0
 (SQL Overall)178691636.79626293.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.