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 “finalises” 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
finalises12291152(None) 
finalise113112571finalise_
finalised13338011finalised
finalisms14318831finalisms
finalists123010161finalists
finalizes212810741finalizes
canalises11515492canalises
finales104016012final__es
finalis103313662finali__s
finalism133010362finalis_m
finalist113014732finalis_t
finalities1349912finalities
finalize202711022finalize_
finalized22279242finalized
finalizer21307922finalizer
finalizers22264902finalizers
finises10312902fin__ises
focalises14139952focalises
penalises11912772penalises
signalises1145912signalises
vitalises12310092vitalises
alkalises13167483alkalises
anaclises1147863_anaclises
analyses11149963_analyses
annalists949063annalists
banalizes201210093banalizes
bialies93618413bi_ali_es
binaries10314183binari_es
binarisms1346413binarisms
bubalises1346323bubalises
canalise10816213canalise_
canalised12810913canalised
canalizes201113783canalizes
civilises14106093civilises
dialists9411413di_alists
dialyses1236133di_alyses
equalises1847253equalises
falsies103515013f__alsies
fantasises1395883fantasises
faradises13248983faradises
fatalisms1439113fatalisms
fatalists12310023fatalists
fayalites1546063fayalites
figulines1345043figulines
filariases1343983filariases
fillies103420253fi_lli_es
finagles12237553fina_gles
finale94116763final__e_
finalising1446673finalising
finality1448343finali_ty
finals94316163final___s
finances1338663fina_nces
fineries112416753fineri_es
finesses111912343fin_esses
finfishes1846043fin_fishes
finishes1438983fin__ishes
finites10315923fin__ites
finless102810783fin_les_s
finlike14279063fin_like_
fiscalists1544673fiscalists
fishlines15246843fishlines
fixatives2243353fixatives
focalise131210373focalise_
focalised15156953focalised
focalizes23159323focalizes
formalises15258993formalises
fraises104215693f_ra_ises
idealises1047783idealises
idolises938763_idolises
incises93414893_in_cises
inclines10313143_inclines
incloses101610533_incloses
inulases838763_inulases
kinases113511123kina__ses
legalises1038563legalises
liaises7311053li_a_ises
linearises1046343linearises
localises111411463localises
metalises11315073metalises
mineralises1357873mineralises
minimises1347163minimises
moralises11314003moralises
nasalises948113nasalises
oxalises1538503_oxalises
penalise101013763penalise_
penalised12108833penalised
penalizes20911853penalizes
realises82420183_realises
ruralises939123ruralises
signalise1046393signalise_
signalised1244243signalised
signalizes2046463signalizes
sinapisms1344793sinapisms
tantalises101010103tantalises
totalises9311783totalises
urinalyses1362323urinalyses
valises103516273__valises
vandalises1446813vandalises
vinasses1135703vina_sses
visualises1345123visualises
vitalise11310743vitalise_
vitalised1347203vitalised
vitalisms1448513vitalisms
vitalists1239223vitalists
vitalizes2139923vitalizes
vocalises141710333vocalises

Search took 10 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.453394461.4
2DLD Change Limit1486411068.67317138.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.17219482.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.