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 “textual” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
textual144460(None) 
textural1544941textural
dextral1577002dextral
sexual1338422sex_ual
tactual936202tactual
tectal83713252tect_al
tertial7313862tertial
textually1944032textually
textuary1842672textuary
texture1497082texture
actual8311023_actual
asexual1443983asex_ual
benthal1247963benthal
bestial9311643bestial
censual937663censual
cental84420963cent_al
central93114473central
contextual1954363contextual
dental74319173dent_al
dentural948083dentural
dextran1586163dextran
equal1449823_e_qual
estral64716513_estral
estrual7367933_estrual
eventual1144883eventual
extol1247893_ext_ol
extoll1334863_extoll
extra1239003_extra_
extras13310223_extras
factual1246723factual
festal94213563fest_al
fetal85623373fe_t_al
fetial95716193fe_tial
gestural946033gestural
lethal939803le_thal
lexical1637363lexical
meatal84114733meat_al
mental84521603ment_al
metal75427383me_t_al
mutual838503_mutual
neutral737923neutral
petal76526893pe_t_al
peytral1287503peytral
rectal84418143rect_al
refutal1046943refutal
rental63922033rent_al
retial64724993re_tial
retral64419743re_tral
ritual6310623_ritual
sensual738053sensual
septal84513383sept_al
setal56430903se_t_al
sextan13389643sext_an
sextuple1762773sextuple
sextuply2052193sextuply
subtextual1952103subtextual
teal45546503te___al
tecta74215523tect_a_
tectum10328603tectu_m
tectums11306423tectums
teetotal844533teetotal
tegua6109563te_gua_
teguas768013te_guas
telial65815363te_lial
tepal76319583te__pal
tergal72912833te_rgal
tertials8510073tertials
tertian7511193tertian
testa54822043test_a_
testae64216253test_ae
testudo843363testudo
tetanal738023tetanal
tetra53417953te_tra_
tetrad73612053te_trad
tetras63017623te_tras
tetryl935693te_tryl
texas126514933tex__as
text116033933text___
textile1437223textile
texts125515043text__s
texturally2043853texturally
textured1695483textured
textures1597523textures
tissual745193tissual
total55321823t_ot_al
toxical1637643toxical
ventral103612173ventral
vestal94615573vest_al
vestral104111013vestral
vestural1156473vestural
victual1246253victual
virtual1045913virtual

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 Filter1786911340270.406440125.6
2DLD Change Limit134027926.98319193.3
3Display Results92920.0332787.9
 (SQL Overall)178691927.42224075.9
 
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.