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

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

121 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
fragmentation1923387(None) 
fragmentations20213561fragmentations
fragmentating2062422fragmentating
argumentation16103583argumentation
augmentation1554393_augmentation
fermentation1756823f_ermentation
fomentation1647713f__omentation
fragmentarily2262173fragmentarily
fragmentate1752683fragmentat__e
fragmentated1962023fragmentat_ed
fragmentates1852583fragmentat_es
frequentation2552633frequentation
lamentation13106573_la_mentation
ornamentation1573613ornamentation
pigmentation1754483_pigmentation
regimentation1695433_regimentation
segmentation1556003_segmentation
alimentation14105334_alimentation
argumentations1783274argumentations
assentation1146184__assentation
augmentations1654124_augmentations
cementation1559704__cementation
depigmentation20103044depigmentation
documentation18144724documentation
fermentations1856274f_ermentations
flagellation1652894flag_ellation
fomentations1746794f__omentations
fragmental1653644fragmenta___l
fragmentally2183024fragmenta_lly
fragmentary2072594fragmenta__ry
fragmenting1843244fragmen__ting
fragmentize2652414fragmen__tize
fragmentizing2982024fragmentizing
frequentations2652244frequentations
lamentations1495984_la_mentations
mentation11313984____mentation
orientation1147574or__ientation
ornamentations1673254ornamentations
pigmentations1854094_pigmentations
placentation1694154pla_centation
presentation1448994pr_esentation
regimentations1784854_regimentations
sedimentation1654834sedimentation
segmentations1655594_segmentations
accentuation1653465__accentuation
acceptation1765325__acceptation
affectation1943845__affectation
agitation10311225__ag__itation
agnation9311725__ag__n_ation
alienation1048795__alien_ation
alimentations1594995_alimentations
ammoniation1545905__ammoniation
amputation1447345__a_mputation
argumentative1962265argumentative
assentations1245835__assentations
attenuation1144185__attenuation
attestation1145185__attestation
augmentative1852715_augmentative
bromination1547815br_omin_ation
catenation1249525_ca_ten_ation
cementations1659015__cementations
commendation1946515_commendation
crenation11412925cr___en_ation
crimination1549415cr_imin_ation
damnation1238405_da_m_n_ation
deamination14411545dea_min_ation
dentation10315245____dentation
depigmentations21102845depigmentations
documentations19144485documentations
emendation1346555___emendation
evagination1546565evag_in_ation
exaggeration2153865exagge_ration
examination2058455exa_min_ation
facilitation1746575f_acilitation
fascination1646795f_ascin_ation
fermentative20113895f_ermentative
fetation11613145f____e_tation
flagellations1752235flag_ellations
forestation1447005f__orestation
fractionation1853205fractionation
fragment1448375fragmen__t___
fragmentariness2171405fragmentariness
fragmented1743035fragmen__t_ed
fragmentized2851935fragment_ized
fragmentizes2752315fragment_izes
fragments1546215fragmen__t__s
fraternization26174065fraternization
frequentative28131765frequentative
fulmination1655885f_ulmin_ation
gestation10310665___g_estation
gravitation1545515gra__vitation
imagination1447195imag_in_ation
implementation2063155implementation
indentation1248375__indentation
lamination12311225_la_min_ation
margination1447435marg_in_ation
mentations12312585____mentations
orientations1246915or__ientations
origination1267095orig_in_ation
ostentation1146965__ostentation
oxygenation2252875oxyg_en_ation
pagination1348995_pag_in_ation
placentations17103635pla_centations
plantation1248535pla___ntation
premeditation1855705pr_emeditation
presentations1548135pr_esentations
protestation1456365pr_otestation
racemization2565965_racemization
recantation1349865_r_ecantation
regeneration1348195_reg_eneration
remediation1449215_r_emediation
reorientation1375595reorientation
replantation1445525_replantation
restation9316915_r___estation
rumination12410835_r_umin_ation
sedimentations1754415sedimentations
stagnation1145545stag__n_ation
sustentation1255025_sustentation
trabeation1245885tra_be__ation
transmutation1554405transmutation
vegetation1448215_veg_e_tation

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901219.06313769.2
3Display Results1211210.0801512.5
 (SQL Overall)1786911219.28319249.3
 
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.