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

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

60 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
crystallinities2071591crystallinities_
crystallinity2172204crystallinit___y
crystallites17143904crystall__it_es_
crystalline16154565crystallin___e__
crystallises17134195crystall__i_ses_
crystallite16134505crystall__it_e__
crystallization2962245crystallizati_on
crystallizes26134105crystall__i_zes_
castabilities1748836c_asta_bilities_
crossabilities1855726crossa_bilities_
crystalizes25145786crysta_l__i_zes_
crystallise16134396crystall____i_se
crystallised18153596crystall__i_se_d
crystallising1982836crystall__isi_ng
crystallizable3071656crystallizable__
crystallize25134236crystall__i_ze__
crystallized27123756crystall__i_ze_d
crystallizer26133516crystall__i_ze_r
crystallizers27182896crystall__i_zers
crystallizing2883206crystall__izi_ng
crystalloids1862736crystall___oids_
salinities10410956___s_a_linities_
trustabilities16105856trusta_bilities_
alkalinities1653007__alka_linities_
apostolicities1861867apost_olicities_
brushabilities2154007brusha_bilities_
brutalities1345447br_uta_l__ities_
callosities1345087c____allosities_
caninities12410497c____a_ninities_
catholicities2053127c__atholicities_
causalities1346227caus_a_l__ities_
causticities1654007caust___icities_
certainties1353767c_erta__in_ties_
consanguinities18141597consanguinities_
countabilities1856697counta_bilities_
creativities1755787cr__ea_tivities_
creditabilities2065297credita_bilities_
crestfallenness207607crestfallen__ness
crystalize24145837crysta_l__i_ze__
crystalized26145427crysta_l__i_ze_d
crystalizing2785497crysta_l__izi_ng
crystalloid1762927crystall___oi__d
crystalloidal19101887crystall___oidal
cutabilities1649147c__uta_bilities_
cyclicities1754707c_y___clicities_
erasabilities1549637eras_a_bilities_
frontalities1555577fronta_l__ities_
instabilities1549887_insta_bilities_
irritabilities1647327irrita_bilities_
masculinities171754627_mas_culinities_
printabilities1847327printa_bilities_
rascalities1347227_rasca_l__ities_
recrystallizes2862187recrystall__i_zes_
rentabilities15411267_renta_bilities_
rusticities1346847_rust___icities_
stabilities13511787___sta_bilities_
stolidities1245447___st_olidities_
testabilities1549967_testa_bilities_
tractabilities1846617tracta_bilities_
treatabilities1657627treata_bilities_

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.343520965.0
2DLD Change Limit95024608.53011140.0
3Display Results60600.0461304.3
 (SQL Overall)178691608.91920034.9
 
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.