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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
misallocation175336(None) 
misallocations1853091misallocations
misallocating1852312misallocating
mislocation15126412mis__location
allocation1248573___allocation
dislocation14147503dis__location
misallocate1552723misallocat__e
misallocated1762353misallocat_ed
misallocates1652643misallocat_es
misapplication2263343misapplication
mislocations16145653mis__locations
reallocation1454493_reallocation
suballocation1761623suballocation
allocations1347774___allocations
allocution1244084___allocution
bilocation1446124bi___location
collocation1547174__collocation
disassociation1763284disassociation
discoloration16124724discoloration
dislocations15136984dis__locations
metallization24176864metallization
misallotting1552114misallo_tting
misapplications2363074misapplications
miscalculation2083034miscalculation
miseducation1793454mis_education
mislocating1645894mis__locating
misquotation23152834mis_quotation
reallocations1553804_reallocations
suballocations1861484suballocations
advocation1645745___advocation
allegation1146815___allegation
allocating1347385___allocating
allocator1145785___allocat_or
allocutions1353985___allocutions
avocation14168995___a_vocation
bilocations1545295bi___locations
collocations1646405__collocations
defalcation1746225defa_l_cation
desalination13411135desa_lination
disaffection2153205disaffec_tion
disapprobation2162665disapprobation
disassociations1863165disassociations
disclamation1754245dis_clamation
discolorations17104305discolorations
dislocating1546735dis__locating
disrelation1248815disrel__ation
dissociation1556645dis__sociation
distillation1347745distil_lation
divarication1855905diva_rication
echolocation1952815_echolocation
finalization2459925fina_lization
illation8311945_i__ll__ation
implication1747775_i_mplication
inculcation1557245_incul_cation
installation1254915install__ation
invocation1547545_i__nvocation
isallobaric1561155_isallobari_c
isolation9311645_is___olation
lallation939495__lall__ation
location102113915_____location
malefaction1853405m__alefaction
malformation1953325m__alformation
malposition1553965m__alposition
mastication15610295m__astication
melioration1368185m__elioration
metallizations25126505metallizations
misallot1047005misallo__t___
misallots1144535misallo__t__s
misallotted1451765misallo__tted
misassumption1961505misassumption
miscalculations2172835miscalculations
miscaption1644765mis____caption
miscegenation1863135miscegenation
miscitation1547775mis__citation
miscreation1547725mis__creation
misdirection1754165misdirec_tion
miseducations18113295mis_educations
misestimation1794725misestimation
misevaluation18153625misevaluation
misfunction1853945mis_func_tion
misinformation2172595misinformation
mislocate13107715mis__locat__e
mislocated15196255mis__locat_ed
mislocates14107225mis__locat_es
misposition1555685mis__position
misquotations24182725mis_quotations
misutilization25155485misutilization
moralization23411615mora_lization
mystification2346195mystification
nasalization2149385nasa_lization
palliation1248505__pall_iation
reallocating1573665_reallocating
relocation12312115___relocation
salivation1349815__sa_livation
saltation9312005__sa_l_tation
salutation1048905__sa_lutation
salvation1239295__sa_l_vation
spallation1247025_spall__ation
suffocation1953375__suffocation
sulcation11710735__s_ul_cation
sulfonation1444265__sulfonation
titillation1145045titill__ation
translocation1554685translocation
vallation1239755__vall__ation
visualization2557935visualization
vitalization24410975vita_lization

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.390458182.1
2DLD Change Limit1247901067.86015876.6
3Display Results1061060.0761394.7
 (SQL Overall)1786911068.32621461.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.