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

69 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
transvaluates1611325(None) 
transvaluate15133521transvaluate_
transvaluated17112781transvaluated
transvalues1454072transvalu__es
translates10411703trans__l_ates
transvaluating1862733transvaluating
transvaluation1763363transvaluation
transvaluations1863023transvaluations
transvalue1353943transvalu__e_
transvalued1552993transvalu__ed
reevaluates1453014_r_eevaluates
revaluates13246794_r__evaluates
tantalates10106704t_an_tal_ates
translate9412274trans__l_ate_
translated1149294trans__l_ated
translocates1455394trans_locates
transmigrates1663844transmigrates
transmutes1247304trans__mu_tes
transudates1246374trans__udates
transvaluing1653424transvalu_ing
transvestites1663084transvestites
devaluates14266065___devaluates
evaluates12247355____evaluates
granulates1148465gran__ul_ates
misevaluates1782445_misevaluates
reescalates13123615_reescal_ates
reevaluate1353145_r_eevaluate_
reevaluated1552835_r_eevaluated
resalutes947435_r_es_alu_tes
retranslates12124065retrans__l_ates
revaluate12277105_r__evaluate_
revaluated14306365_r__evaluated
strangulates1384825stran_gul_ates
tantalate9107375t_an_tal_ate_
tantalites1099285t_an_tal_ites
tantaluses10104595t_an_talu_ses
transacted1346635trans_a__cted
transacts1157365trans_a__ct_s
transalpine1365035trans_alpine_
transaminases1562985transaminases
transaxles1745065trans_a__xles
transduces1345605trans__du_ces
transferases1555085trans_ferases
transfigures1653255transfigu_res
transfuses1346745trans__fu_ses
translator1047225trans__l_ator
translators1156445trans__l_ators
transliterates1462575transliterates
translocate1355535trans_locate_
translocated1554425trans_located
transmigrate1554125transmigrate_
transmigrated1773205transmigrated
transmute1157185trans__mu_te_
transmuted1345595trans__mu_ted
transparences17103755transparences
transplanted1574525trans_planted
transplanter1474565trans_planter
transplanters1583065trans_planters
transplants1355815trans_pl_ants
transsexuals1962325transsexua_ls
transshapes1674315trans__shapes
transudate1146745trans__udate_
transudes1047595trans___u_des
transversals1562995transversa_ls
transverses1445905transv__erses
transvestite1553925transvestite_
triangulates1363815trian_gul_ates
unevaluated1553075__unevaluated
valuates112811205_____valuates

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.453394461.4
2DLD Change Limit124790699.08013743.4
3Display Results69690.0461500.0
 (SQL Overall)178691699.57918654.5
 
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.