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

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

103 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
collateralizing276206(None) 
collateralities17152333collateralities
collateralize2472693collateraliz__e
collateralized2672123collateraliz_ed
collateralizes2572483collateraliz_es
lateralizing2257053___lateralizing
collaterality1862564collateral__ity
literalizing2256454___literalizing
centralizing2458055c__ent_ralizing
collaborating1852585collabora__ting
collateral1244115collateral_____
collaterally1752825collateral___ly
collaterals1353385collateral____s
colonializing2553605co_l_onializing
computerizing2952835computer__izing
dematerializing28163565_dematerializing
denaturalizing2563515_denaturalizing
dollarizing2254335dolla__r__izing
illegalizing2353035_ill__egalizing
immaterializing29102805_immaterializing
lateraling11148805___lateral__ing
lateralling1244635___lateral_ling
laterizing2049095___later__izing
liberalizing2455185___liberalizing
materializing2595975___materializing
naturalizing2255755___naturalizing
palatalizing2454895_palat__alizing
politicalizing2862575po_liticalizing
rematerializing27153525_rematerializing
volatilizing2553685vo_lat__ilizing
alliterating1354276_allitera__ting
canalizing22410426c___a__nalizing
capitalizing2656156c___apitalizing
caramelizing2693266c_arame__lizing
cartelizing2346356c__arte__lizing
catabolizing2653446c___atabolizing
catalyzing2544776c___at__alyzing
catechizing2853976c___ate_chizing
categorizing2553456c___ategorizing
catheterizing2862416catheter__izing
cauterizing2345946c__auter__izing
centralising1555936c__ent_ralising
characterizing3161706character__izing
cicatrizing2553906c_icat_r__izing
collaboration1763006collaborati_on_
collaborations1872746collaborati_ons
collaring12310546colla__r____ing
collating12312766collat______ing
collectivizing3182036coll_ectivizing
colorizing2249636co_l__or__izing
commercializing3362716commercializing
communalizing2952866co__mmunalizing
computerising2062636computer__ising
concatenating1853266concatena__ting
conceptualizing3173086conceptualizing
concertizing2655636co__ncer_tizing
connaturalities17162606connaturalities
conservatizing2983096co__nservatizing
constraining1554546co_nst_ra_ining
containerizing26201876container__izing
contextualizing3462496contextualizing
copolymerizing3361366copolymer__izing
counteracting1856286co_untera_cting
counterarguing18113406co_unterarguing
counterclaiming2262926co_unterclaiming
counterfeiting2054026co_unterfeiting
counterpoising19164196co_unterpoising
counterrallying2162276co_unterrallying
countervailing2063736co_untervailing
crystalizing2785496c_ryst__alizing
decentralizing2763366decent_ralizing
demineralizing2792996_demineralizing
desacralizing2653876_desa_cralizing
eternalizing2256246____eternalizing
externalizing3054616___externalizing
federalizing2655246___federalizing
fraternizing2553406__frater_nizing
generalizing2346356___generalizing
hospitalizing2873476hospit__alizing
internalizing2356216___internalizing
labializing2345946___la_bializing
lateralize1949056___lateraliz__e
lateralized2147406___lateraliz_ed
lateralizes2048436___lateraliz_es
legalizing2147546___l__egalizing
liberalising1564126___liberalising
materialising16114496___materialising
mineralizing2466586___mineralizing
moralizing2249746mo_____ralizing
naturalising1354116___naturalising
neutralizing2276446__neut_ralizing
obliterating1553396_oblitera__ting
ostracizing2344566_o__st_racizing
pluralizing2345216__pl__uralizing
polarizing2248796po_la__r__izing
polymerizing29113846po_lymer__izing
presterilizing26122756_presterilizing
sacralizing2347406___sa_cralizing
solarizing2048286so_la__r__izing
sterilizing2146906____sterilizing
structuralizing2781636structuralizing
totalizing2079226to___t__alizing
volatilising1652346vo_lat__ilising

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 Filter178691950240.356501941.0
2DLD Change Limit950241038.23611537.6
3Display Results1031030.0761355.3
 (SQL Overall)1786911038.66820615.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.