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

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

54 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
disconcerting195457(None) 
disconcertingly2471542disconcertingly
disconnecting1953882disconnecting
discontenting1755072discontenting
concerting15313893___concerting
discomforting2262613discomforting
disconcert1548263disconcert___
disconcerted1854343disconcert_ed
disconcertment2163003disconcertment
disconcerts1655233disconcert__s
disconfirming2262333disconfirming
discovering1845363disco_ver_ing
misconceiving2362103misconceiving
misconnecting2053543misconnecting
preconcerting2084413preconcerting
conceiting15311774___conceiting
concerning1548904___concerning
concertina14410614___concertina
concertino14910844___concertino
concreting1539874___concreting
converting16313134___converting
decongesting1753734d_econgesting
discanting1449454discan___ting
discepting1658474dis___cepting
discerning1447864dis___cerning
discoloring1544744disco_lor_ing
discolouring1652644discolour_ing
discomfiting2153144disco_mfiting
discommending2261914discommending
disconcertments2282494disconcertments
disconnection1854204disconnection
disconnections1954024disconnections
discontinuing1783244discontinuing
discording1547664disco___rding
discounting1547444disco__unting
discoursing1544854disco__ursing
dishonoring1653864dishon_or_ing
disinfecting1954694dis_infecting
disinfesting1754434dis_infesting
disinheriting1853474dis_inheriting
disinterring1454204dis_interring
disinvesting1754204dis_investing
dislocating1546734dislo_c_ating
disordering1444384dis_order_ing
disorienting14155654dis_orienting
disporting1439824dispo___rting
disserting121310854dis___serting
dissociating1655364disso_ciating
distorting1239584disto___rting
misconception2163994misconception
misconceptions2263574misconceptions
misconducting2152714misconducting
misconstruing18111924misconstruing
reconverting1876404_reconverting

Search took 7 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.376475242.0
2DLD Change Limit95024545.70316662.1
3Display Results54540.0301800.0
 (SQL Overall)178691546.10929250.5
 
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.