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 “marlines” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
marlines10381871(None) 
carlines103521641carlines
malines93625601ma_lines
marines93928011mar_ines
marline93320951marline_
marlings113713491marlings
marlins93420471marlin_s
marlites103415261marlites
airlines8312792airlines
alines65735222_a_lines
arsines73518812_arsines
berlines102315452berlines
carbines123617532carbines
carline93923612carline_
carlings114015852carlings
carlins93921912carlin_s
carmines123617862carmines
darlings103710382darlings
earliness939692earliness
hairlines1237132hairlines
harmines132715142harmines
jawlines18126362jawlines
kaolines1239292kaolines
machines15312892machines
mailings113011922mailings
mainlines1138512mainlines
malices114316622ma_lices
maline84529082ma_line_
mallings113413092mallings
manliness111310122manliness
marblings14225542marblings
margined1237742margined
margins103815192margin_s
marinas93519382mar_inas
marine84230402mar_ine_
mariner93315992mar_iner
mariners103113862mar_iners
markings153410242markings
marlier92614772marli_er
marliest102415182marli_est
marlin84220902marlin__
marling103322762marlin_g
marlite92917072marlite_
marmites122212792marmites
marries93825282marri_es
martinet10319642martinet
martinets1138882martinets
martinis103311612martinis
martins93322062martin_s
merlins93015812merlin_s
midlines112613332midlines
millines102718062millines
moraines10314362moraines
murines93718222mur_ines
myelines1337122myelines
pralines102217722pralines
purlines103514052purlines
ratlines83815292ratlines
salines74029412sa_lines
sardines92815562sardines
taglines92210832taglines
valines104520212va_lines

Search took 5 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 Filter1786911210590.1401276364.3
2DLD Change Limit121059624.07629700.4
3Display Results62620.0331878.8
 (SQL Overall)178691624.24942054.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.