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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
typify173452(None) 
tepefy1434802tepefy
typey135511882typ_ey
typic124511962typi_c
typier1137332typier
typing124110582typing
typist1139822typist
typy126013042typ__y
aerify122810113aerify
amplify1744083amplify
atypic13337653atypi_c
basify1437513basify
byplay1634193byplay
citify1437443citify
codify1537163codify
deify124112763_deify
dopily123510463dopily
edify12308563_edify
expiry1834653expiry
gasify1336333gasify
gypsy14636993gyp_sy
hyping15408483hyping
ignify1334513ignify
minify1439253minify
modify1537173modify
mystify1843563mystify
nazify2134233nazify
nidify1336763nidify
notify1236943notify
ossify1244973ossify
pacify1667473pacify
pily96132733__pily
piny911838353__piny
pipy115421513__pipy
pity96031933__pity
pixy166117763__pixy
purify14399153purify
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
ropily113312443ropily
salify12311373salify
spicy125417713_spicy
spiff133616403_spiff
spiffy17326223_spiffy
spiky146014113_spiky
spiny104921303_spiny
spiry105017353_spiry
stupefy1542903stupefy
tackify1934493tackify
taffy145110823t_affy
taping94222393taping
tapir75917063tapi_r
tapirs84113173tapirs
tapis75028863tapi_s
tariff12711363tariff
tepid8314313tepi_d
tepidly1334403tepidly
tepoy10312163tep_oy
terrify1336353terrify
testify13246943testify
thrift12412043thrift
thrifty1634193thrifty
tidily102811393tidily
tidy86822413t__idy
tiff104727723t__iff
tinily94014433tinily
tiny76134633t__iny
tipi69924433tipi__
tipis76019923tipi_s
tipoff1436383tipoff
tippy125411793tip_py
tipsily1236043tipsily
tipsy106010503tip_sy
tivy1014516863t__ivy
toffy145310283t_offy
topi67830393topi__
topiary1245813topiary
topic95721503topi_c
topics104714583topics
toping94122993toping
topis76025833topi_s
torrify1335013torrify
triply114211023triply
trippy13457803trippy
tumefy1434223tumefy
tupik1149003tupi_k
tupiks1235493tupiks
turfy114315403t_urfy
twiny116012813t_winy
tyin76424003ty_i_n
tying96019843ty_ing
tyiyn11635333ty_iyn
tympany17254603tympany
tyning105510413tyning
typal105311153typ_al
type96223743typ__e
typed115815453typ_ed
types105721063typ_es
typhon1436673typhon
typhus14395713typhus
typical1436343typical
typiest1238203typiest
typified1743923typified
typifier1643403typifier
typifies1644963typifies
typifying2143323typifying
typists1236173typists
typo95418123typ__o
typos106015813typ_os
typp115812783typ__p
typps12549303typ_ps
tyring104613023tyring
uglify1333913uglify
unify113611113_unify
uppity1335103uppity
verify153110163verify
vilify1536773vilify
vinify1536923vinify
vivify1834703vivify
yuppify2042163yuppify

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161226.34317770.1
3Display Results1221220.0333697.0
 (SQL Overall)1786911226.51627423.4
 
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.