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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
metalized2141218(None) 
metalised12310461metalised
metalize19414781metalize_
metalizes20414231metalizes
metallized2265581metallized
legalized2047522legalized
melanized2158572melanized
metabolized2553912metabolized
metaled102913872metal__ed
metalise10416052metalise_
metalises11315062metalises
metalled1148972metal_led
metallize2067152metallize_
metallizes2156672metallizes
moralized21310752moralized
mutualized2244632mutualized
penalized211210222penalized
realized182514222re_alized
tetanized1988442tetanized
totalized1949442totalized
vitalized2239112vitalized
actualized2245333actualized
alkalized23146603alkalized
banalized21118703banalized
bestialized2346013bestialized
botanized2147273botanized
brutalized2275063brutalized
canalized21611693canalized
catalyzed2444993catalyzed
centralized2348133centralized
detailed10319873deta_iled
detained103111643deta_ined
devitalized25106953devitalized
dualized1937403_dualized
equalized2846863equalized
fertilized2346513fertilized
feudalized2444303feudalized
finalized22279243finalized
focalized24157963focalized
hepatized2446253hepatized
idealized2046653idealized
legalised1145843legalised
legalize1839103legalize_
legalizer1946323legalizer
legalizes1938673legalizes
localized21168833localized
mealie82519803me_ali_e_
mealier93015903me_ali_er
mealies92821933me_ali_es
mechanized2745883mechanized
medaled113411603medal__ed
medalled1246883medal_led
mediatized2344753mediatized
melanize19410303melanize_
melanizes20410383melanizes
melodized2245453melodized
memorized23138983memorized
metabolize2364953metabolize_
metabolizes2454643metabolizes
metalhead1543203metalhead
metaling111613713metali_ng
metalist10519353metali_st
metalists11412653metalists
metalizing22511353metalizing
metallike1555893metallike_
metalline1158733metalline_
metalloid1246183metalloid
methodized2644823methodized
metricized2445423metricized
mettled103510543mettl__ed
mineralized2346633mineralized
mobilized2346743mobilized
moralised1239663moralised
moralize19313923moralize_
moralizer2049473moralizer
moralizes20312853moralizes
motorized2148643motorized
mutualize2045473mutualize_
mutualizes2144943mutualizes
nasalized1946753nasalized
nebulized2154073nebulized
neutralized21117013neutralized
notarized1947143notarized
pearlized2145533pearlized
penalised12108823penalised
penalize19912753penalize_
penalizes20911823penalizes
petaled103614143petal__ed
petaline10314883petaline_
petalled1138683petal_led
realised92214533re_alised
realize162717083re_alize_
realizer172412113re_alizer
realizes173116843re_alizes
retailed94113963reta_iled
retained93016093reta_ined
retaliated1148433retaliated
retallied1046783retallied
reutilized2046993reutilized
revitalized24117563revitalized
ritualized2046553ritualized
ruralized1947903ruralized
serialized20810673serialized
sexualized2745963sexualized
stylized21175863_stylized
taliped1078203__taliped
tantalized20118913tantalized
tetanised1096513tetanised
tetanize17109953tetanize_
tetanizes1889833tetanizes
totalised1048073totalised
totalize17311523totalize_
totalizer1847993totalizer
totalizes18311043totalizes
utilized1847543_utilized
velarized2256803velarized
verbalized2547603verbalized
vernalized2348413vernalized
vitalised1347203vitalised
vitalize20310503vitalize_
vitalizer2147303vitalizer
vitalizes2139923vitalizes
vocalized24178813vocalized

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.1561145455.1
2DLD Change Limit1486411237.84318952.1
3Display Results1231230.0631952.4
 (SQL Overall)1786911238.06222164.6
 
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.