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

69 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
finalizer2130792(None) 
finalize202711021finalize_
finalized22279241finalized
finalizers22264901finalizers
finalizes212810741finalizes
finalise113112572finalise_
finalised13338012finalised
finalises122911522finalises
vitalizer2147302vitalizer
alkalizer22155563alkalizer
analyzer20155053_analyzer
banalize191010933banalize_
banalized21118703banalized
banalizes201210093banalizes
canalize19914493canalize_
canalized21611693canalized
canalizes201113783canalizes
civilizer23104323civilizer
dialyzer2143113di_alyzer
equalizer2745753equalizer
fantasizer2294163fantasizer
faradizer22215373faradizer
finagler12194953fina_gler
finale94116763final__e_
finales104016013final__es
finalis103313663finali__s
finalism133010363finali_sm
finalisms14318833finalisms
finalist113014733finali_st
finalists123010163finalists
finalities1349903finalities
finality1448343finali_ty
finalizing2347983finalizing
financier1443713financier
finlike14279063fin_like_
finnier10319953fin_ni_er
focalize22139503focalize_
focalized24157963focalized
focalizes23159323focalizes
formalizer24257873formalizer
idealizer1945473idealizer
idolizer1845663_idolizer
incliner1038513_incliner
inlier63615363_in_li_er
jinglier1655233jingli_er
kindlier1345763kindli_er
kinglier1345633kingli_er
legalizer1946323legalizer
localizer20147713localizer
mineralizer2245303mineralizer
minimizer2244793minimizer
moralizer2049473moralizer
penalize19912753penalize_
penalized211210243penalized
penalizes20911853penalizes
realizer172412113_realizer
signalize1946913signalize_
signalized2145733signalized
signalizes2046463signalizes
tantalizer19107283tantalizer
tinglier956403tingli_er
tinklier1255443tinkli_er
totalizer1847993totalizer
visualizer2263853visualizer
vitalize20310503vitalize_
vitalized2239113vitalized
vitalizers2244723vitalizers
vitalizes2139923vitalizes
vocalizer23187573vocalizer

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.436409841.7
2DLD Change Limit148641698.06318434.9
3Display Results69690.0302300.0
 (SQL Overall)178691698.52920951.0
 
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.