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

51 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
scatteration145292(None) 
scatterations1552541scatterations
alteration10612903__alteration
castration12410803_cast_ration
catenation1249523_ca_tenation
saturation1049803s_a_turation
acceleration1654814acceleration
adulteration1353664adulteration
aeration8319934__a__eration
alliteration1285164alliteration
alterations11511664__alterations
altercation1347014__altercation
alternation1147624__alternation
attention946104__atte_ntion
attenuation1144184__attenuation
attestation1145184__attestation
attraction1276954__att_raction
attrition966964__att_rition
botheration1654654_botheration
calibration1545994_calibration
cancelation1547774_cancelation
captivation1846174_captivation
caseation1199514_ca_se_ation
castigation1447974_castigation
castrations13410054_cast_rations
catenations1348364_ca_tenations
cauterization24187754_cauterization
cooperation15410024_cooperation
deaeration11313014dea__eration
deuteration1249104_deuteration
exaggeration2153864exaggeration
exasperation2154024exasperation
exenteration1955294exenteration
inattention1152724inatte_ntion
incarceration1753564incarceration
iteration9515034___iteration
laceration1249574_la_ceration
literation10511414__literation
maceration1449614_ma_ceration
maturation1249514_ma_turation
obliteration1453894obliteration
reiteration11412164_reiteration
saltation9312004s_alt__ation
satiation9313434s_a_t_iation
saturations1148574s_a_turations
scalation11311074sca___lation
scatterbrain1661314scatterbrain
scattergood1551634scatter_good
scattergun1351494scatter__gun
scattering1398014scatter__ing
scattershot1651704scatter_shot

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.390458182.1
2DLD Change Limit124790518.17015274.2
3Display Results51510.406125.6
 (SQL Overall)178691518.96619929.8
 
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.