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

60 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
metallike155589(None) 
metalline1158731metalline
metallize2067151metallize
petallike1554631petallike
metalise10416052meta_lise
metalize19414782meta_lize
metallic1247642metalli_c
metallics1346132metallics
metalling1249592metalling
metallist1159672metallist
metallized2265582metallized
metallizes2156682metallizes
seallike12108322se_allike
beadlike15137253be_adlike
beaklike13155773be_aklike
beamlike16115843be_amlike
beanlike14146843be_anlike
bearlike14156793be_arlike
deathlike1753823deathlike
eellike1138233_e_ellike
heathlike1944323heathlike
jetlike18276763jet__like
jewellike2342243jewellike
leaflike1534713le_aflike
manlike133012783m__anlike
maplike15299273m__aplike
mealie82519813me_a_li_e
mealtime1245123me_altime
medallic1345113medalli_c
medalling1346923medalling
medallion1244073medallion
medallist1246643medallist
metabolite1446023metabolite
metabolize2364953metabolize
metaling111613723meta_ling
metalised12310463meta_lised
metalises11315073meta_lises
metalist10519353meta_list
metalized21412183meta_lized
metalizes20414243meta_lizes
metalled1148993metall_ed
metallists1266713metallists
metalloid1246203metalloid
metalloids1344863metalloids
metalware1443603metalware
moatlike1446993m_oatlike
mothlike1736063mot_hlike
netlike11308913net__like
peaklike13115373pe_aklike
pealike131211273pe_a_like
petaline10314883peta_line
retallied1046783retallied
retallies939373retallies
seamlike14127183se_amlike
stalklike1243903_stalklike
starlike1238813_starlike
taglike12278913__taglike
taillike1237863__taillike
tealike111111083te_a_like
veillike1534603ve_illike

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.420425454.8
2DLD Change Limit148641606.55022693.3
3Display Results60600.0134615.4
 (SQL Overall)178691606.98325589.4
 
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.