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

95 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
facilitated175364(None) 
facilitate1544571facilitate_
facilitates1644301facilitates
facilitator1652982facilitator
habilitated1782932habilitated
acclimated1745153_acclimated
affiliated1744193affili_ated
ciliated11510943__cili_ated
debilitated1543803debilitated
facelifted1952173faceli_fted
facilitating1853993facilitating
facilitation1746573facilitation
facilitative2052883facilitative
facilitators1752783facilitators
facilitatory2062293facilitatory
facilities1549823facilit_ies
felicitated1743563felicitated
filiated12610083f__ili_ated
habilitate1573803habilitate_
habilitates1673583habilitates
militated1248803__militated
unciliated1348053uncili_ated
vacillated1654613vacil_lated
acclimate1546234_acclimate_
acclimates1645914_acclimates
acetated112010684_ac__etated
acidulated14195154_acidulated
acierated1238284_aci_erated
acquitted2143504_acquit_ted
activated1567884_ac_tivated
aculeated1247714_acul_eated
acuminated1545874_acuminated
acylated1437864_acyl__ated
affiliate1545324affili_ate_
affiliates1644894affili_ates
agitated1038414_a__gitated
backfitted2253254backfit_ted
backlighted2452814backlighted
backlisted1944504backli_sted
capacitated1852454capacitated
capitated14159044__capitated
cavitated15177354__cavitated
ciliate9514594__cili_ate_
ciliates10413444__cili_ates
cogitated1346324__cogitated
conciliated1645644concili_ated
debilitate1344864debilitate_
debilitates1444474debilitates
decapitated1744944decapitated
digitated1286954__digitated
excogitated2252354excogitated
fabricated1845404fa_bricated
fabulated1546324fabul__ated
facetted1445744fac__et_ted
facilitations1845764facilitations
facility1638244facili__t_y
falcated1438474fa__l_cated
fasciated1546134fa_sci_ated
fasciculated2053054fasciculated
fascinated1645874fa_scinated
felicitate1544464felicitate_
felicitates1644204felicitates
filiate10414234f__ili_ate_
filiates11412654f__ili_ates
filtrated1345964f__iltrated
flitted114011644f___lit_ted
foliated1249914f__oli_ated
humiliated1643984humili_ated
imitated1138264___imitated
jacklighted2951854jacklighted
jaculated19289054jacul__ated
laciniate1156844lacini_ate_
lactated1138864lac___tated
machinated1845664mac_hinated
maculated142411504macul__ated
militate10311674__militate_
militates11310884__militates
nictitated1344394nic_titated
oscillated1343854oscil_lated
paclitaxel215984pac_litaxel
palliated1238494pa_lli_ated
palpitated1544234pa_lpitated
precipitated1954014precipitated
rehabilitated1961684rehabilitated
salivated1337474sa__livated
sanitated1068994sa__nitated
tailcoated1343284ta_ilcoated
tailgated1145124ta_il_gated
umbilicated1852654umbilicated
unacclimated1952814unacclimated
vaccinated1855444vac_cinated
vacillate1456834vacil_late_
vacillates1555704vacil_lates
validated1446494va__lidated
vaticinated1753434vaticinated

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 Filter1786911488190.1531167915.0
2DLD Change Limit148819957.86018933.7
3Display Results95950.0501900.0
 (SQL Overall)178691958.06322161.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.