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

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

93 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
suballocation176162(None) 
suballocations1861481suballocations
allocation1248573___allocation
misallocation1753363misallocation
reallocation1454493_reallocation
allocations1347774___allocations
allocution1244084___allocution
bilocation1446124__b_ilocation
collocation1547174__collocation
misallocations1853094misallocations
publication1746574pub__lication
reallocations1553804_reallocations
spallation1247024s_pall__ation
subcollection1961714subcollec_tion
sublation11311014sub__l__ation
sublimation1557184sub__limation
subluxation2043824sub__luxation
subrogation1446004sub__rogation
subtilization2456634subtilization
suffocation1953374su__ffocation
sulcation11710734su___l_cation
sulfonation1444264su__lfonation
supplication1855394su_pplication
advocation1645745___advocation
allegation1146815___allegation
allocating1347385___allocating
allocator1145785___allocat_or
allocutions1353985___allocutions
avocation14168995___a_vocation
bilocations1545295__b_ilocations
collocations1646405__collocations
cupellation1544145cupell__ation
defalcation1746225defa_l_cation
dislocation14147505__dislocation
duplication1647295du__plication
echolocation1952815_echolocation
embrocation1744585emb__rocation
jubilation1946055jub_il__ation
labanotation1451655laba_notation
lallation939495__lall__ation
location102113915_____location
lubrication1546345lub__rication
metallization24176865metallization
misallocating1852315misallocating
mislocation15126415__mislocation
palliation1248505__pall_iation
publications1845835pub__lications
pullulation1343345pu__llulation
qualification2745035qu_alification
reallocating1573665_reallocating
relocation12312115___relocation
rubrication1547125rub__rication
salivation1349815s__a_livation
saltation9312005s__a_l_tation
salutation1048905s__a_lutation
salvation1239295s__a_l_vation
scalation11311075s_ca_l__ation
sibilation12128775sib_il__ation
spallations1356105s_pall__ations
stabilization2466195stabilization
subaudition1452695suba__udition
subcollections2061725subcollec_tions
subduction1544685sub__duc_tion
suberization2359245sub_erization
subgeneration1652605subgeneration
subirrigation1652645subirrigation
subjection2165975sub__jec_tion
subjugation2143705sub__jugation
subjunction2253335sub_junc_tion
sublations12410115sub__l__ations
sublimations1646085sub__limations
subluxations2143385sub__luxations
subordination1654175subordination
subornation1346495sub__ornation
subpopulation1962665subpopulation
subrogations1545455sub__rogations
subsaturation1553075subsaturation
subsection1496785sub__sec_tion
subsidization2553985subsidization
substation1248995sub___station
subtilizations2556065subtilizations
subtraction1545625sub_trac_tion
suffocations2053095su__ffocations
sulcations1289585su___l_cations
sulfation1288785su___l_fation
sulfonations1543925su__lfonations
supplantation1762665supplantation
supplications1954915su_pplications
syllabication2052285syllabication
translocation1554685translocation
umbilication1884745_umbilication
unallocated14113325_unallocat_ed
vallation1239745__vall__ation

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790938.53314624.4
3Display Results93930.0601550.0
 (SQL Overall)178691938.73320461.6
 
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.