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

71 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
accommodation2215261(None) 
accommodations23202501accommodations
accommodating2372062accommodating
accommodational2471552accommodational
accommodative2562012accommodative
accommodator2161722accommodat_or
accommodate2062133accommodat__e
accommodated2261923accommodat_ed
accommodates2162203accommodat_es
accommodators2261743accommodators
acclamation17144754acclam__ation
acclimation17127094acclim__ation
accommodatingly28101314accommodatingly
accumulation18153804acc_umulation
accustomation1961934accustomation
commendation1946514__commendation
commination171111644__commination
commotion1576984__commo__tion
commutation1748004__commutation
recommendation2183224recommendation
unaccommodating2571074unaccommodating
abomination1547485a_bo_mination
acceleration1654815acc_eleration
accentuation1653465acc_entuation
acceptation1765325acc__eptation
acclamations18164045acclam__ations
acclimations18146295acclim__ations
accordion1443125acco__rd__ion
accreditation18112875accreditation
acculturation17173345acculturation
accumulations19143625acc_umulations
accusation1466905acc___usation
accustomations2061725accustomations
ammoniation1545905a___mmoniation
atomization2249245a_to_mization
automation1249145auto_m__ation
autorotation1255015auto_rotation
autoxidation2053785auto_xidation
collocation1547175__collocation
coloration12913185__co_loration
combination17108805__combination
commemoration1853885_commemoration
commendations2055805__commendations
comminations18810485__comminations
comminution17105015__comminution
commodities1845495__commodities
commotions1686845__commo__tions
commutations1847265__commutations
compilation1749315__compilation
composition1746795__composition
computation1748715__computation
condonation1448855__condonation
connotation1347985__connotation
consolation13410985__consolation
convocation1847885__convocation
coronation12412075__co_ronation
corotation12410975__co_rotation
corporation151210655__corporation
decomposition2053075decomposition
echolocation1952815echo_location
immolation1446105___immolation
incommodities2063085incommodities
incorporation17115615incorporation
locomotion1452595loco_mo__tion
recombination19106175recombination
recommendations22113095recommendations
recompilation1955155recompilation
recomposition1953415recomposition
recomputation1974395recomputation
recordation1449265reco__rdation
unaccommodated2471265unaccommodat_ed

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.376475242.0
2DLD Change Limit124790719.01613840.9
3Display Results71710.0461543.5
 (SQL Overall)178691719.43818933.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.