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 “fenestrations” 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.

88 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
fenestrations169540(None) 
fenestration1596071fenestration_
defenestrations1993302defenestrations
penetrations1448852pene_trations
defenestration18173543defenestration_
detestations1347583detest_ations
federations1548883fede__rations
forestations1546323forest_ations
frustrations1544533f_rustrations
generations12311423gene__rations
menstruations1585053men_struations
mensurations1445713men_surations
ministrations1555463ministrations
penetration1349893pene_tration_
registrations1446903registrations
sequestrations23182993sequestrations
venerations14411313vene__rations
attestations1244464attest_ations
castrations13410074__castrations
celebrations1645744cele_brations
cementations1659014cement_ations
cerebrations1646964cere_brations
concentrations1877074concentrations
consecrations1749214consecrations
contestations1547744contest_ations
deaerations12311674deae__rations
decelerations1646424decelerations
defenestrating19112544defenestrati_ng
degenerations1546354degenerations
degustations1444834degust_ations
delectations1547454delect_ations
demonstrations1795674demonstrations
denaturations1444954denaturations
denegations1348544dene__gations
denervations1657094dene_rvations
denigrations1447354den_igrations
denotations1239854den_ot_ations
dentations11413634den__t_ations
desecrations1559214dese_crations
detestation1248364detest_ation_
devastations1645824devast_ations
effectuations2151954effectuations
enervations1478574_ene_rvations
enumerations14135514_enumerations
execrations2048924_exe_crations
exenterations2054484_exenterations
eyestrains1343564_eyestra_i_ns
federation1449574fede__ration_
fenestrate1345294fenestrat___e
fenestrated1554244fenestrat__ed
fermentations1856274ferment_ations
fetations12511384f__e_t_ations
filtrations1445624f__iltrations
fomentations1746794foment_ations
forestation1447004forest_ation_
frustration1444814f_rustration_
generation11312434gene__ration_
gestations1139774__gest_ations
hebetations1656464hebe_t_ations
illustrations1353154illustrations
impetrations1645444impe_trations
infestations1546624infest_ations
lustrations1147624__lustrations
menstruation1455224men_struation_
mensuration1346494men_suration_
mentations12312584men__t_ations
ministration1465844ministration_
molestations1475474molest_ations
nitrations10312044__n_itrations
orchestrations19113304orchestrations
penetrating1447664pene_trati_ng
perpetrations1746374perpetrations
prostrations1449774_prostrations
redecorations1645084redecorations
regenerations1447144regenerations
registration1347544registration_
reinfestations1793884reinfest_ations
remonstrations16116494remonstrations
renaturations1355964renaturations
renegotiations15113374renegotiations
reregistrations1672824reregistrations
restations10315844__rest_ations
restorations12410964__restorations
sensations1059854sen_s__ations
sequestration22133134sequestration_
vegetations1547324vege_t_ations
veneration13412344vene__ration_
venesections1752934venes_ections

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 Filter178691950240.393454684.5
2DLD Change Limit95024886.56014485.4
3Display Results88880.0501760.0
 (SQL Overall)178691887.00325516.4
 
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.