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

51 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
metallists126671(None) 
medallists1344361medallists
metalists11412661meta_lists
metallist1159671metallist_
bimetallists1652602bimetallists
medalists1249372meda_lists
medallist1246642medallist_
mentalists12410482menta_lists
metalises11315072meta_lises
metalist10519352meta_list_
metallics1346132metalli_cs
metallizes2156682metallizes
bimetallisms1852563bimetallisms
bimetallist1553373bimetallist_
cellists1038563ce__llists
diallists1056003_diallists
fatalists12310023fata_lists
gestaltists1252423gestaltists
heraldists1443953heraldists
legalists1047943lega_lists
mealless10288363me_alles_s
medalist11414213meda_list_
medallions1343263medallions
melanists1148623mela_nists
mentalisms1449313menta_lisms
mentalist11515553menta_list_
metabolisms1754243metabolisms
metalise10416053meta_lis_e
metalised12310463meta_lised
metalizes20414243meta_lizes
metallic1247643metalli__c
metallike1555893metalli_ke
metalline1158733metalli_ne
metalling1249593metalli_ng
metallize2067153metalli_ze
metallized2265583metallized
metalloids1344863metalloids
metallurgists1661373metallurgists
metaplasms1654263metaplasms
methodists1644973methodists
metrists1039853met__rists
moralists11311103mora_lists
muralists1148163mura_lists
mutualists1244853mutualists
phallists1445723_phallists
realists83014843re_a_lists
retallies939373retalli_es
tallises82713263__tallises
tallits73215993__talli_ts
totalists9310753tota_lists
vitalists1239223vita_lists

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 Filter1786911406030.420425454.8
2DLD Change Limit140603516.69021016.9
3Display Results51510.0301700.0
 (SQL Overall)178691517.14025026.8
 
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.