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

43 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
overdirected195290(None) 
overdirect1644512overdirect__
overdirects1752812overdirect_s
overcorrected2163053overcorrected
overdecked2164603overd__ecked
overdirecting2053743overdirecting
overdressed1644973overd_ressed
overreacted1745653over__reacted
overtreated1547413over_treated
redirected1444773_re_directed
codirected1653004__codirected
directed1238234____directed
misdirected1752464_misdirected
nondirected1552954_nondirected
overacted1539634ove___racted
overarched1946094over_ar_ched
overasserted1673464overasserted
overbetted1645644over__betted
overbreed1548044over_bre__ed
overbriefed2042974overbrie_fed
overdared1439164overdar___ed
overdresses1546194overd_resses
overdried1439014overd_r__ied
overedited1547214overedi___ted
overexerted2245274over_exerted
overgirded1644614overgir__ded
overharvested2361804overharvested
overheated1739484over__heated
overlighted1944214overli_ghted
overmelted1646904over__melted
overnighted1953994overni_ghted
overoperated1876044overoperated
overpriced18107524over_pric_ed
overprinted1785934over_printed
overprotected2162844overprotected
overrated13313084over__r_ated
overreached2044364over__reached
overstressed1654024overstressed
overstretched2271934overstretched
overstrewed1843684overstre_wed
overtired131310254overtir___ed
overwetted1745664over__wetted
undirected1445024__undirected

Search took 8 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 Limit124790437.08017625.7
3Display Results43430.0133307.7
 (SQL Overall)178691437.48323879.6
 
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.