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

80 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
overcaution165515(None) 
overcautions1755261overcautions
overaction1547992over_action
overcautious1752742overcautious
operation11314003oper_a_tion
overactions1648213over_actions
overcasting1748513overcasting
overreaction1754923overreaction
overtaxation2253683overtaxation
overvaluation1965093overvaluation
precaution1447243pre_caution
recaution1148093_re_caution
vernation12311083_verna_tion
aberration1267204aberra_tion
aeration8319934_aer_a_tion
altercation1347014alterca_tion
arcuation11410584__arcuation
avocation14168994av_oca_tion
caution93013524____caution
conversation1747804conversa_tion
covariation1646774covaria_tion
enervation1369474enerva_tion
evacuation1547164ev_acuation
evection131910834eve_c__tion
evocation142010294ev_oca_tion
execration1949834execra_tion
execution1846304exe_c_ution
furcation1448354_furca_tion
incaution1146584__incaution
iteration9515034iter_a_tion
moderation1348654moder_a_tion
nervation12610244_nerva_tion
observation1665064observa_tion
operations12312954oper_a_tions
oration71617714o__r_a_tion
ovation101510024ov___a_tion
overacting16310914over_acting
overactive1847264over_active
overacute1447114overacut__e
overcalling1747324overcalling
overcast132411974overcast___
overcasted1647794overcast_ed
overcastings1853954overcastings
overcasts14217854overcast__s
overcontrol1652594overcontrol
overcounting1846614overcounting
overcuring16108764overc_uring
overcut12310424overc_ut___
overcuts1337514overc_ut__s
overcutting1746824overcutting
overeaten12312784overea_t_en
overeating141016534overea_ting
overeducation1955374overeducation
overevaluation2074524overevaluation
overexertion22115404overexertion
overhating17910954overha_ting
overhauling1846034overhauling
overlain112112444overla__i_n
overrating14814204overra_ting
overreactions1854724overreactions
oversalting1548574oversalting
oversaturation1794464oversaturation
oversaucing1746264oversaucing
oversecretion1863944oversecretion
overtaxations2353514overtaxations
overvaluations2064614overvaluations
ovulation1238984ov_ula_tion
perception1688614_perception
precautions1546554pre_cautions
recautions1247814_re_cautions
revocation15410814revoca_tion
seriation9318064_seria_tion
serration9414074_serra_tion
toleration1048964toler_a_tion
vacation131911894_v_aca_tion
variation12312394_varia_tion
venation11513504_ve_na_tion
vernations13310334_verna_tions
vexation1838784_ve_xa_tion
vocation132311984_v_oca_tion

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 Filter1786911488190.436409841.7
2DLD Change Limit148819809.34315928.4
3Display Results80800.0501600.0
 (SQL Overall)178691809.82918180.0
 
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.