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

206 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
tryout941076(None) 
trout57332571tr_out
tryouts1035311tryouts
buyout11310102buyout
grayout1148512grayout
grout65330422gr_out
layout9513702layout
payout11714652payout
rout46153282_r_out
ryot75528562_ryo_t
tout46753822t__out
trot46351312tr_o_t
trouts66116632tr_outs
trouty95211792tr_outy
tryst84716222try_st
turnout7410282turnout
about75229083_about
arbour84211333arbour
ardour74110903ardour
argot67728653argo_t
armour84411853armour
aroynt9312893aroynt
bayou10512363bayou_
bayous11411153bayous
bout66353293__bout
brut66537963br__ut
bryony1435833bryony
bugout9311863bugout
burgout1049773burgout
burnout9310453burnout
buyouts1235203buyouts
carryout1346793carryout
clout75330463_clout
copout10418783copout
croft105622683cr_oft
croup95616783cr_oup
croute84617273cr_oute
crypt123715233cry_pt
cutout8315923cutout
devout10712993devout
dimout9414243dimout
droit65127123dr_oit
dropout10410003dropout
dropt86924433dr_opt
drouk1039433dr_ouk
drouth104410103dr_outh
dryest104811123dryest
drylot1037403drylot
dugout8310363dugout
ergot65422893ergo_t
flout86226203_flout
front85029223fr_ont
frost84727833fr_ost
glout65925813_glout
gout56646003__gout
grayouts1244693grayouts
griot65328413grio_t
groat65531973gr_oat
grot55942053gr_o_t
group85413923gr_oup
grouts75015613gr_outs
grouty104710983gr_outy
guyot9314523guyo_t
joyous16276763joyous
knout95018263_knout
kraut95221403kr_aut
krubut1245553krubut
layouts1046483layouts
lout45952143__lout
mahout11415813mahout
out38072153___out
payouts1247303payouts
pigout9314613pigout
pout65752553__pout
poyou102611523poyou_
poyous112911623poyous
precut102016533precut
prost75434103pr_ost
proud84615483pr_oud
putout8315113putout
ragout7317183ragout
rebut75927383_rebut
recut74729243_recut
redout71820253redout
riot45947223_rio_t
roost55730933_roost
root45655923_r_oot
rot37282953_r_o_t
roue45941743_r_oue
roup66627693_r_oup
roust55532063_r_oust
route55132073_r_oute
routh86423073_r_outh
routs57133413_r_outs
roux117419363_r_oux
rubout8313563rubout
runout6414873runout
rut35560523_r__ut
ryots85313783_ryots
scout75031453_scout
setout64719473setout
shout85433173_shout
snout54530633_snout
spout75029633_spout
sprout8419403sprout
stout57434053_stout
stroud7310383str_oud
strut56030733str__ut
surtout7411683surtout
tabour84011323tabour
takeout1149873takeout
tarot55943933taro_t
taut47048963t__aut
tenour62610733tenour
thou76722213t_hou_
thous86017263t_hous
throat94819753throat
thruput1243863thruput
thymus14324743thymus
timeout948593timeout
toft77441653t__oft
toit46353063t__oit
toot45958883t__oot
torot56139943toro_t
torous64319033torous
tort46967463t__ort
tost48351923t__ost
tot38884773t__o_t
tour45530383t__our
touts54830393t__outs
toyo76925453toyo__
toyon86715673toyo_n
toyons95512133toyons
toyos87519143toyo_s
tract75635713tr_act
tragus749233tragus
trait56940843tr_ait
trapt76433393tr_apt
trayful1344583trayful
treat56240353tr_eat
tret46653533tr__et
trevet94818913trevet
tribute937313tribute
tricot8317753tricot
trijet133916553trijet
trio45233343trio__
triode75311893triode
triol55521363trio_l
triolet73219523triolet
triols66117803triols
trios55528093trio_s
triose64715383triose
trivet93721883trivet
troak95213573tr_oak
trock114817603tr_ock
trod57627953tr_o_d
trode65322853tr_ode
trog57628213tr_o_g
trogs67022603tr_ogs
trois57226093tr_ois
troke94821053tr_oke
troll54416533tr_oll
tromp95815803tr_omp
trona54118953tr_ona
trone55131863tr_one
troop76417533tr_oop
troops85712783troops
trooz145016153tr_ooz
trop66833303tr_o_p
trope75725803tr_ope
troth85622203tr_oth
trots56629943tr_ots
trough108512033tr_ough
troupe84812433tr_oupe
trove85221923tr_ove
trow78031423tr_o_w
trows88826183tr_ows
trowth1277883tr_owth
troy77429683tr_o_y
troys86418613tr_oys
truant6315783truant
true46725853tr__ue
truest64816193truest
trug55720043tr__ug
trust55426853tr_ust
truth85214153tr__uth
try66529673try___
trying104214073trying
tryma1037223try_ma
trymata1244223trymata
tryste9399583tryste
trysts9448793trysts
tumour8137403tumour
turbot8914263turbo_t
turnouts845413turnouts
tut36758093t___ut
tyrant9315333tyrant
tyro76622363tyro__
tyros85118593tyro_s
vrouw11507343vr_ouw
workout1448393workout
wryest12429113wryest
you66641823__you_
your78623433__your
yous76230653__yous
youth115315043__youth

Search took 6 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.393454684.5
2DLD Change Limit1127162064.75023729.7
3Display Results2062060.0633269.8
 (SQL Overall)1786912065.20634324.0
 
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.