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

58 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
accommodating237206(None) 
accommodatingly28101312accommodatingly
accommodation22152612accommodation
accommodations23202502accommodations
accommodative2562012accommodative
unaccommodating2571072unaccommodating
accommodate2062133accommodat__e
accommodated2261923accommodat_ed
accommodates2162203accommodat_es
accommodational2471553accommodational
accommodator2161723accommodat_or
accommodators2261743accommodators
acclimating1845294acclim__ating
accumulating1953184acc_umulating
commutating1846024__commutating
incommoding1952804incommod__ing
abominating1644845a_bo_minating
accelerating1753735acc_elerating
accentuating1762835acc_entuating
accolading1644795acc___olading
accompanying2471305acco_mpanying
accomplishing25121485accomplishing
according1545275acco__rd__ing
accosting1446735acc___o_sting
accounting1544925acc___ounting
accrediting1752465acc__rediting
acculturating1852555acculturating
acuminating1645805a_c_uminating
ammoniating1644065a___mmoniating
apocopating1853245a_po_copating
automating1389305auto_m__ating
autorotating1373845auto_rotating
cohobating1845025__co_hobating
collocating1645915__collocating
colocating1548625__co_locating
combating16310165__co_m_bating
comforting18165935__comfo_rting
commemorating1953075_commemorating
commentating1957045__commentating
commenting1749175__comm_enting
comminuting1844505__comminuting
committing1746685__comm_itting
commodifying2651815__commodifying
commodities1845495__commodities
commoving1944985__commo__ving
commuting16288445__comm__uting
comporting17199165__compo_rting
compositing1846265__compositing
composting17178055__compo_sting
coronating13410175__co_ronating
corotating1349325__co_rotating
discommoding2152565discommod__ing
immolating1545055___immolating
incommodities2063085incommodities
incorporating1854125incorporating
locomoting1543505loco_mo__ting
recommitting1954135recomm_itting
unaccommodated2471265unaccommodat_ed

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 Limit124790587.64016333.8
3Display Results58580.0461260.9
 (SQL Overall)178691588.07622126.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.