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

65 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
metallist115967(None) 
medallist1246641medallist
metalist10519351meta_list
metallists1266711metallists
bimetallist1553372bimetallist
medalist11414212meda_list
medallists1344362medallists
mentalist11515552menta_list
metalise10416052meta_lise
metalists11412662meta_lists
metallic1247642metalli_c
metallics1346132metallics
metallike1555892metallike
metalline1158732metalline
metalling1249592metalling
metallize2067152metallize
bimetallism1752893bimetallism
bimetallists1652603bimetallists
cellist9314423ce__llist
diallist949553_diallist
etatist7415033_eta_tist
fatalist11314973fata_list
gestaltist1154293gestaltist
heraldist1346403heraldist
legalist9512393lega_list
mealiest102215973me_aliest
mealless10288363me_alless
measliest1147173me_asliest
medalists1249373meda_lists
medallic1345113medalli_c
medalling1346923medalling
medallion1244073medallion
melanist10313053mela_nist
mentalism13511643menta_lism
mentalists12410483menta_lists
metabolism1654893metabolism
metaling111613723meta_ling
metalised12310463meta_lised
metalises11315073meta_lises
metalize19414783meta_lize
metalled1148983metall_ed
metallized2265583metallized
metallizes2156683metallizes
metalloid1246203metalloid
metalloids1344863metalloids
metallurgist1561783metallurgist
metals84520883meta_l_s_
metaplasm1544793metaplasm
methodist1547013methodist
metrist9317063met__rist
moralist10316663mora_list
muralist10312983mura_list
mutualist1146403mutualist
petallike1554633petallike
phallist1338983_phallist
realist73225383re_a_list
retallied1046783retallied
retallies939373retallies
tallest7317093__tallest
tallis63319963__tallis_
tallish103313583__tallish
tallit63422733__talli_t
tallits73215993__tallits
totalist8315583tota_list
vitalist11313393vita_list

Search took 9 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.423422437.4
2DLD Change Limit148641657.76319147.4
3Display Results65650.0331969.7
 (SQL Overall)178691658.21921741.2
 
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.