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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
centralising155593(None) 
centralizing2458051centralizing
generalising1454102generalising
neutralising1374582neutralising
canalising1349363can__alising
centralise1269603centralis__e
centralised1446603centralis_ed
centralises1349293centralis_es
centralism1448643centralis__m
centralisms1547403centralis_ms
centralist12511063centralis__t
centralistic1655113centralistic
centralists1348143centralis_ts
centralities1448623centralities
decentralizing2763363decentralizing
entraining1147643_entra_ining
generalizing2346353generalizing
metalising1348943me_t_alising
mineralising1595153mineralising
neutralizing2276443neutralizing
penalising1347623pen__alising
tantalising1246203tant_alising
bestializing2456164bestializing
brutalising1444074brut_alising
canalizing22410424can__alizing
cannibalising18182394cannibalising
capitalising1754454capitalising
cartelising1444794cart_elising
centralest1247144centrales__t
centrality1547744central__ity
centralize2149964central__ize
centralized2348154centrali_zed
centralizer2246834centrali_zer
centralizers2354334centralizers
centralizes2249424centrali_zes
centrals102712034central_s___
centrifuging1951854centrifuging
centring112112954centr____ing
centupling1543014centupl__ing
constraining1554544constra_ining
containing13410934cont_a_ining
contracting16610474contra_cting
contradicting1954074contradicting
contrasting1459354contra_sting
contravening1853564contravening
contriving1648194contr__iving
controlling1445424control_ling
demoralizing2547144demoralizing
denaturalizing2563514denaturalizing
detraining1267674de_tra_ining
energising1245234_ener_gising
engrailing1244854_engra_iling
engraining1245224_engra_ining
enravishing1852234_en_ravishing
entailing1039394_ent_a_iling
enterprising1554084_enterprising
enthralling1543844_enthral_ling
entrancing1346784_entra_ncing
entrapping1544874_entra_pping
equalising2065994_e_qualising
externalising2153394_externalising
extraditing2064284_extraditing
fantasising1554214fant_asising
federalizing2655244federalizing
finalising1446674fin__alising
fundraising1652784fundra_ising
internalising1455624_internalising
legalising1245744le__galising
liberalising1564124liberalising
memorialising1853064memorialising
metalizing22511364me_t_alizing
mineralizing2466584mineralizing
moralising1347624__moralising
nasalising1145594__nasalising
naturalising1354114naturalising
normalising1444974__normalising
ostracising1443874_ostracising
outraising1139904_outra_ising
penalizing2249924pen__alizing
realising10313174re___alising
reraising10313774re__ra_ising
restraining1247534restra_ining
retraining11310244re_tra_ining
revitalising1654664revitalising
ruralising1146444__ruralising
scandalising1653254scan_dalising
sensualizing2254904sensualizing
serialising12167004se_rialising
tantalizing2158074tant_alizing
tetanising1146174te_t_anising
totalising1147314_tot_alising
vandalising1644354van_dalising
vitalising1446844_vit_alising

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 Filter1786911247900.406440125.6
2DLD Change Limit124790936.78018405.6
3Display Results93930.0462021.7
 (SQL Overall)178691937.23224708.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.