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

106 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
finalize20271102(None) 
finalise113112571finalise
finalized22279241finalized
finalizer21307921finalizer
finalizes212810741finalizes
banalize191010932banalize
canalize19914492canalize
finale94116762final__e
finalis103313662finali_s
finalised13338012finalised
finalises122911522finalises
finalism133010362finalism
finalist113014732finalist
finality1448342finality
finalizers22264902finalizers
finlike14279062fin_like
focalize22139502focalize
penalize19912752penalize
signalize1946912signalize
vitalize20310502vitalize
alkalize21177633alkalize
analyze19167013_analyze
animalize2048553animalize
annualize1845613annualize
banalized21118703banalized
banalizes201210093banalizes
canalise10816213canalise
canalized21611693canalized
canalizes201113783canalizes
civilize22106393civilize
dialyze2044433di_alyze
dualize1759763_dualize
equalize2648023equalize
fanglike1636823fanglike
fanlike142610503fan_like
fantasize2196053fantasize
faradize21237823faradize
fayalite1447053fayalite
feudalize2254873feudalize
fiberize2246143fiberize
figuline1256033figuline
filariae1148473filariae
filmlike1734443filmlike
finable122213623fina_ble
finagle11238313fina_gle
finagling1434703finagling
final83922033final___
finales104016013final_es
finalisms14318833finalisms
finalists123010163finalists
finalities1349903finalities
finalizing2347983finalizing
finally13310103final_ly
finals94316163final__s
finance1238573fina_nce
finite9316823fin__ite
fishlike18225873fishlike
fishline14237583fishline
fixative2145083fixative
flintlike1643123flintlike
focalise131210373focalise
focalized24157963focalized
focalizes23159323focalizes
formalize232710033formalize
francize2246853francize
idealize1847873idealize
idolize1737783_idolize
incline9314643_incline
inklike1037033_inklike
kinglike1235093kinglike
legalize1839103legalize
linearize1845753linearize
linelike12159003linelike
localize191410483localize
metalize19414783metalize
mineralize2147773mineralize
minimize2146063minimize
moralize19313923moralize
nasalize1748183nasalize
penalise101013763penalise
penalized211210243penalized
penalizes20911853penalizes
pinelike14188613pinelike
pintsize1955103pintsize
realize162717083_realize
ringlike1336243ringlike
ritualize1847793ritualize
ruralize1739233ruralize
signalise1046393signalise
signalized2145733signalized
signalizes2046463signalizes
sinicize1947333sinicize
tantalize181010573tantalize
tinlike11248803tin_like
totalize17311523totalize
unalike11311533_unalike
vandalize2246793vandalize
vernalize2159843vernalize
virilize2047743virilize
visualize2175583visualize
vitalise11310743vitalise
vitalized2239113vitalized
vitalizer2147303vitalizer
vitalizes2139923vitalizes
vocalize221310153vocalize
winglike1635593winglike

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621067.57619292.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.04522211.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.