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

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

66 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
accommodational2471551accommodational_
accommodatingly28101313accommodati_ngly
accommodation22152613accommodation___
accommodations23202503accommodation__s
accommodating2372064accommodati_n__g
accommodative2562015accommodati___ve
accommodator2161725accommodat_o___r
accommodators2261745accommodat_o__rs
accommodate2062136accommodat_____e
accommodated2261926accommodat____ed
accommodates2162206accommodat____es
acculturational1971666acculturational_
collocational1753056__collocational_
combinational1984086__combinational_
compositional1974056__compositional_
computational1994576__computational_
connotational1554156__connotational_
convocational2054476__convocational_
recombinational21102026recombinational_
unaccommodating2571076unaccommodati_n__g
acclamation17144757acclam__ation___
acclamations18164047acclam__ation__s
acclimation17127097acclim__ation___
acclimations18146297acclim__ation__s
accumulation18153807acc_umulation___
accumulations19143627acc_umulation__s
accustomation1961937accustomation___
accustomations2061727accustomation__s
associational1552937asso__ciational_
avocational1645187a____vocational_
biconditional1862247bico__nditional_
biconditionals1961457bico__nditionals
coeducational1853297__coeducational_
commendation1946517__commendation___
commendations2055807__commendation__s
commination171111647__commination___
comminations18810487__commination__s
commodiously2262617__commod__iously
commotion1576987__commo__tion___
commotions1686847__commo__tion__s
communicational2383077__communicational_
commutation1748007__commutation___
commutations1847267__commutation__s
compensational2073527__compensational_
compositionally2462287__compositionally
computationally2462497__computationally
conditional1447117__co__nditional_
conditionals1554977__co__nditionals
conformational21153717__conformational_
conjugational2353697__conjugational_
consociational1853557__consociational_
correlational15113677__correlational_
deformational19122977deform__ational_
denominational1752547deno_minational_
documentational2061967documentational_
foundational1652857__fo_undational_
incommodiously2471627incommod__iously
informational1854347inform__ational_
nonvocational1853707__nonvocational_
occupational1883007occ___upational_
promotional1555637_pro_mo__tional_
recommendation2183227recommendation___
recommendations22113097recommendation__s
reformational18113427reform__ational_
summational1553687__summ__ational_
unconditional1663467unco__nditional_

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 Filter178691950240.346516448.0
2DLD Change Limit95024668.03011833.6
3Display Results66660.0461434.8
 (SQL Overall)178691668.42221217.2
 
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.