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

92 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
suballocations186148(None) 
suballocation1761621suballocation_
allocations1347773___allocations
misallocations1853093misallocations
reallocations1553803_reallocations
allocation1248574___allocation_
allocutions1353984___allocutions
bilocations1545294__b_ilocations
collocations1646404__collocations
misallocation1753364misallocation_
publications1845834pub__lications
reallocation1454494_reallocation_
spallations1356104s_pall__ations
subcollections2061724subcollec_tions
sublations12410114sub__l__ations
sublimations1646084sub__limations
subluxations2143384sub__luxations
subrogations1545454sub__rogations
subtilizations2556064subtilizations
suffocations2053094su__ffocations
sulcations1289584su___l_cations
sulfonations1543924su__lfonations
supplications1954914su_pplications
advocations1755415___advocations
allegations1246045___allegations
allocating1347385___allocati_ng
allocators1246085___allocat_ors
allocution1244085___allocution_
avocations15168685___a_vocations
bilocation1446125__b_ilocation_
collocation1547175__collocation_
cupellations1643805cupell__ations
defalcations1845195defa_l_cations
dislocations15136985__dislocations
duplications1746285du__plications
echolocations2052625_echolocations
embrocations1843985emb__rocations
jubilations2045365jub_il__ations
labanotations1551485laba_notations
lallations1038745__lall__ations
locations112512745_____locations
lubrications1645735lub__rications
metallizations25126505metallizations
misallocating1852315misallocati_ng
mislocations16145655__mislocations
palliations1347725__pall_iations
publication1746575pub__lication_
pullulations1442965pu__llulations
qualifications2844585qu_alifications
reallocating1573665_reallocati_ng
relocations13311145___relocations
rubrications1646265rub__rications
salivations1448735s__a_livations
saltations10310625s__a_l_tations
salutations1147645s__a_lutations
salvations1338135s__a_l_vations
scalations1239785s_ca_l__ations
sibilations13127935sib_il__ations
spallation1247025s_pall__ation_
stabilizations2565605stabilizations
subauditions1552585suba__uditions
subcollection1961715subcollec_tion_
subductions1644505sub__duc_tions
suberizations2468775sub_erizations
subgenerations1752515subgenerations
subirrigations17102405subirrigations
subjections2296355sub__jec_tions
subjugations2253415sub__jugations
subjunctions2353465sub_junc_tions
sublation11311015sub__l__ation_
sublimation1557185sub__limation_
subluxation2043825sub__luxation_
subordinations1754005subordinations
subornations1446145sub__ornations
subpopulations2062385subpopulations
subrogation1446005sub__rogation_
subsaturations1672575subsaturations
subsections1597105sub__sec_tions
subsidizations2653735subsidizations
substations1348245sub___stations
subtilization2456635subtilization_
subtractions1645375sub_trac_tions
suffocation1953375su__ffocation_
sulcation11710735su___l_cation_
sulfations13107815su___l_fations
sulfonation1444265su__lfonation_
supplantations1862525supplantations
supplication1855395su_pplication_
syllabications2152025syllabications
translocations1664235translocations
umbilications1994415_umbilications
vallations1339085__vall__ations

Search took 6 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.340525561.8
2DLD Change Limit95024925.53317174.0
3Display Results92920.0462000.0
 (SQL Overall)178691925.91930189.4
 
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.