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

42 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
overarticulates207262(None) 
overarticulate1972711overarticulate_
overarticulated2182531overarticulated
overstimulates1983653over_stimulates
rearticulates1554623_re_articulates
articulates1349044____articulates
disarticulates1773694_disarticulates
inarticulates1554194__inarticulates
misarticulates1883194_misarticulates
overparticular2171144overparticula__r
overregulates1794544over_r_egulates
overspeculates21133404over_speculates
overstimulate1883844over_stimulate_
overstimulated2093674over_stimulated
particulates1647364___particulates
rearticulate1455044_re_articulate_
rearticulated1654154_re_articulated
articulate12410245____articulate_
articulated1447625____articulated
disarticulate1673845_disarticulate_
disarticulated1873325_disarticulated
gesticulates1555045_ge__sticulates
inarticulate1454565__inarticulate_
matriculates1655475___matriculates
misarticulate1793335_misarticulate_
misarticulated1973005_misarticulated
overestimates1854865overesti__mates
overinflates1853955ove__r_inflates
overmedicates2153515overmedic__ates
overpopulates2094595ove__rpopulates
overregulate1684495over_r_egulate_
overregulated1894425over_r_egulated
oversaturates1654215oversat__urates
overspeculate20123505over_speculate_
overspeculated22123365over_speculated
particulate1548315___particulate_
reticulates13148875___r_eticulates
unarticulated1653845__unarticulated
vermiculate1855725_ve__rmiculate_
vermiculated2064515_ve__rmiculated
vermiculites1952995_ve__rmiculites
vesiculates1646295_ve___siculates

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 Filter178691658740.373479064.3
2DLD Change Limit65874425.78311391.0
3Display Results42420.0301400.0
 (SQL Overall)178691426.18628886.4
 
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.