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

(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
collateralizing2762061collateralizing_
collateralities17152334collateraliti_es
collateralize2472694collateraliz___e
collateralized2672124collateraliz__ed
collateralizes2572484collateraliz__es
lateralizing2257054___lateralizing_
collaterality1862565collateral__i_ty
literalizing2256455___literalizing_
centralizing2458056c__ent_ralizing_
collaborating1852586collabora__ting_
collateral1244116collateral______
collaterally1752826collateral____ly
collaterals1353386collateral_____s
colonializing2553606co_l_onializing_
computerizing2952836computer__izing_
dematerializing28163566_dematerializing_
denaturalizing2563516_denaturalizing_
dollarizing2254336dolla__r__izing_
illegalizing2353036_ill__egalizing_
immaterializing29102806_immaterializing_
lateraling11148806___lateral__ing_
lateralling1244636___lateral_ling_
laterizing2049106___later__izing_
liberalizing2455186___liberalizing_
materializing2595976___materializing_
naturalizing2255756___naturalizing_
palatalizing2454896_palat__alizing_
politicalizing2862576po_liticalizing_
rematerializing27153526_rematerializing_
volatilizing2553686vo_lat__ilizing_
alliterating1354277_allitera__ting_
canalizing22410427c___a__nalizing_
capitalizing2656157c___apitalizing_
caramelizing2693267c_arame__lizing_
cartelizing2346357c__arte__lizing_
catabolizing2653447c___atabolizing_
catalyzing2544777c___at__alyzing_
catechizing2853977c___ate_chizing_
categorizing2553457c___ategorizing_
catheterizing2862427catheter__izing_
cauterizing2345957c__auter__izing_
centralising1555937c__ent_ralising_
characterizing3161707character__izing_
cicatrizing2553907c_icat_r__izing_
collaboration1763007collaborati_on__
collaborations1872747collaborati_on_s
collaring12310567colla__r____ing_
collating12312787collat______ing_
collectivizing3182037coll_ectivizing_
colorizing2249637co_l__or__izing_
commercializing3362717commercializing_
communalizing2952867co__mmunalizing_
computerising2062637computer__ising_
concatenating1853267concatena__ting_
conceptualizing3173087conceptualizing_
concertizing2655637co__ncer_tizing_
connaturalities17162607connaturaliti_es
conservatizing2983097co__nservatizing_
constraining1554547co_nst_ra_ining_
containerizing26201877container__izing_
contextualizing3462497contextualizing_
copolymerizing3361367copolymer__izing_
counteracting1856287co_untera_cting_
counterarguing18113407co_unterarguing_
counterclaiming2262927co_unterclaiming_
counterfeiting2054027co_unterfeiting_
counterpoising19164197co_unterpoising_
counterrallying2162277co_unterrallying_
countervailing2063737co_untervailing_
crystalizing2785497c_ryst__alizing_
decentralizing2763367decent_ralizing_
demineralizing2792997_demineralizing_
desacralizing2653877_desa_cralizing_
eternalizing2256247____eternalizing_
externalizing3054617___externalizing_
federalizing2655247___federalizing_
fraternizing2553407__frater_nizing_
generalizing2346357___generalizing_
hospitalizing2873477hospit__alizing_
internalizing2356217___internalizing_
labializing2345947___la_bializing_
lateralize1949057___lateraliz___e
lateralized2147407___lateraliz__ed
lateralizes2048437___lateraliz__es
legalizing2147547___l__egalizing_
liberalising1564127___liberalising_
materialising16114497___materialising_
mineralizing2466587___mineralizing_
moralizing2249747mo_____ralizing_
naturalising1354117___naturalising_
neutralizing2276447__neut_ralizing_
obliterating1553397_oblitera__ting_
ostracizing2344567_o__st_racizing_
pluralizing2345217__pl__uralizing_
polarizing2248797po_la__r__izing_
polymerizing29113847po_lymer__izing_
presterilizing26122757_presterilizing_
sacralizing2347407___sa_cralizing_
solarizing2048287so_la__r__izing_
sterilizing2146907____sterilizing_
structuralizing2781637structuralizing_
totalizing2079227to___t__alizing_
volatilising1652347vo_lat__ilising_

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 Filter178691950240.373479064.3
2DLD Change Limit950241039.42310084.3
3Display Results1031030.0761355.3
 (SQL Overall)1786911039.87218100.8
 
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.