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

48 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
overextension236328(None) 
overextensions2463171overextensions
overexpansion2562692overexpansion
hyperextension29152773hyperextension
overattention16113233overattention
overexertion22115403overex_ertion
overexpansions2662483overexpansions
overextending2553913overextending
extension1646294____extension
hyperextensions30192244hyperextensions
overattentions17103184overattentions
overexertions23115194overex_ertions
overextend2144534overexten___d
overextended2453364overexten_ded
overextends2263404overexten__ds
overextraction26153544overextraction
overintensity1962434overintensity
pretension1247534__pre_tension
apprehension1992645appre_hension
comprehension2262975compre_hension
derepression1593135_derepression
extensions1746135____extensions
hypertension2084725_hypertension
overaction1547995overact___ion
overassertion16113515overassertion
overdesign1543825over__de_sign
overeaten12312785overeate____n
overeaters1348635overeaters___
overeducation1955375overeducation
overestimation19125145overestimation
overexercise2463695overex_ercise
overexerting2346495overex_erting
overexpanding2752985overexpanding
overexpectation2972115overexpectation
overexplain2354595overex_plai_n
overexposing2554195overex_posing
overextractions27163255overextractions
overintense1454615overintens__e
overnutrition1663385overnutrition
overpersuasion19152045overpersuasion
overprotection2163615overprotection
oversecretion1863945oversecre_tion
prehension1546315__pre_hension
prerecession1683575prere_cession
pretensions1347085__pre_tensions
recension1148865___re_cension
reprehension1753375repre_hension
retention91611485___re_tention

Search took 10 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.406440125.6
2DLD Change Limit124790489.19013578.9
3Display Results48480.0301600.0
 (SQL Overall)178691489.62618563.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.