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

86 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
finmark1615488(None) 
finmarks17154471finmarks
finnmark17122341finnmark
finback1865822finback
finnmarks18122052finnmarks
mismark1536702mismark
airpark1344923airpark
binary11312223bin_ary
demark134211023_demark
dinar66319893din_ar_
dinars75417563din_ars
earmark1345653earmark
fanfare1336673fanfare
fiar76427333fi__ar_
fiars86720833fi__ars
filar84819293fi_lar_
filmcard1642823filmcard
filmer114112403filmer_
filmers124211293filmers
final83922033fin_a_l
finale94116763fin_ale
finals94316163fin_als
finbacks1965363finbacks
finca104714503finca__
fincas113512073finca_s
finder104020233finder_
finders113717873finders
finer85431563fin_er_
finery124512893fin_ery
finger104920333finger_
fingers113418433fingers
finial92814183finia_l
finials103210153finials
fink117532123fin___k
firearm1237203firearm
firman112211343firma_n
firmans12238523firmans
firmer114712443firmer_
firmers124711443firmers
firmware1643963firmware
footmark1743833footmark
fulmar1137253fulmar_
fulmars1246423fulmars
futhark1744233futhark
imbark14347863_imbark
impark14287073_impark
inarm7314423_in_arm
infare9313083_infare
inmate82917363_inmate
invar839513_invar_
invars9310003_invars
inward10310333_inward
kinara10310373kin_ara
landmark1544153landmark
linear65113343linear_
mark105138063___mark
minipark1643543minipark
mismarks1645893mismarks
nark85230063__n_ark
ninebark1444253ninebark
ostmark1344873ostmark
pinwork16107243pinwork
pugmark1643463pugmark
qindar16317173qindar_
qindarka2241923qindarka
qindars17267423qindars
qintar15359143qintar_
qintars16268573qintars
remark123512373_remark
ringbark1544053ringbark
seamark1336723seamark
simar74920813si_mar_
simars84916933si_mars
sitzmark2342023sitzmark
snark95419943_sn_ark
tanbark1337373tanbark
tidemark1543403tidemark
tinman82411143tinma_n
tinware1038603tinware
tinwork1476993tinwork
titlark1144723titlark
unmask1265903_unmask
zingara1745513zingara
zingare1737143zingare
zingari1745483zingari
zingaro1745123zingaro

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 Filter1786911340270.406440125.6
2DLD Change Limit134027866.36021073.4
3Display Results86860.0302866.7
 (SQL Overall)178691866.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.