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

62 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
predevaluation206238(None) 
reevaluation1554482_re_evaluation
devaluation1547073___devaluation
overevaluation2074513overevaluation
postdevaluation2171843postdevaluation
prerevolution1861943prerevolu_tion
reevaluations1654273_re_evaluations
revaluation1458143_r__evaluation
devaluations1646354___devaluations
evaluation1358184____evaluation
misevaluation18153624_misevaluation
overevaluations2194054overevaluations
overvaluation1965084ove_rvaluation
predestination1765484predestination
reevaluating1653354_re_evaluating
revaluations1557634_r__evaluations
transvaluation1763364transvaluation
undervaluation1882684undervaluation
crenelation1346855crene__l_ation
crenellation1453915crene__llation
dealation10313005___de_al_ation
defalcation1746225___defalcation
devaluating1645055___devaluating
devastation1546735___devastation
devolution1486285___devolu_tion
evacuation1547165____evacuation
evaluations1457325____evaluations
federalization2787035_federalization
misevaluations19133455_misevaluations
overvaluations2064595ove_rvaluations
perpetuation1655345perpe__tuation
perseveration1853795persev_eration
preadaptation1852145pre_adaptation
precaution1447235pr__eca_u_tion
predation12313465pred_____ation
predestinations1865005predestinations
predication16412435pred___ication
predilection1754095pred__ilection
predomination1896535pred_omination
preelection15136485pre_e__lection
premeditation1855705preme_ditation
preparation1549275pr__epa_ration
preselection16154885prese__lection
presentation1448995prese__ntation
preservation1776285prese__rvation
pretermination1854775pretermination
prevarication2055245pr__evarication
redecoration1545995_rede_coration
rededication1646505_rede_dication
reescalation1464085_reescal_ation
reevaluate1353145_re_evaluat__e
reevaluated1552835_re_evaluat_ed
reevaluates1453015_re_evaluat_es
reregulation1346415_reregul_ation
retaliation11612325_r__etaliation
revalidation1657945_r__evalidation
revaluating1545895_r__evaluating
revelation13410925_r__evel_ation
revolution13117565_r__evolu_tion
transvaluations1863025transvaluations
undervaluations1982285undervaluations
valuation1249975_____valuation

Search took 9 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.1261418182.5
2DLD Change Limit95024627.87612065.0
3Display Results62620.0461347.8
 (SQL Overall)178691628.04822203.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.