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

249 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
thrawn1276942(None) 
thraw1110515921thraw_
thraws129211101thraws
thrown1214911441thrown
brawn106018562_brawn
drawn95614242_drawn
prawn105312432_prawn
shawn116417612sh_awn
than76128772th_a_n
thaw107521312th_aw_
thaws116515462th_aws
thrall93810292thrall
thrash12258362thrash
thrave126010272thrave
thrawed1435582thrawed
thrawing1535962thrawing
thrawnly1741792thrawnly
threw1117315712threw_
throw118719732throw_
throws129715232throws
train56529112t_rain
trawl84915872t_rawl
awn68035913___awn
blawn106813703_blawn
brain76229383_brain
bran65740383_bra_n
braw94829563_braw_
brawl106217963_brawl
brawns115614083_brawns
brawny144710603_brawny
braws106425193_braws
brown105619533_brown
buran75225303bura_n
chain105723673ch_ain
chaw126224633ch_aw_
chaws135022463ch_aws
craw97725263_craw_
crawl104916713_crawl
craws105723123_craws
crown105620083_crown
dawn85624203__dawn
drain65222893_drain
draw85623013_draw_
drawl95516013_drawl
draws95119373_draws
drown95515823_drown
fawn105321953__fawn
frown115415973_frown
furan84320013fura_n
gnawn9517783_gnawn
grain65126253_grain
gran56335013_gra_n
grown95317353_grown
haen76229453_h_aen
haw97153273_h_aw_
hawk145521153_h_awk
haws106439443_h_aws
hewn106719853_h_ewn
hwan105716893_hwa_n
ihram10310183ihra_m
ihrams1137173ihrams
impawn1333263impawn
indrawn1145093indrawn
khan115819143kh_a_n
lawn75925633__lawn
loran55925093lora_n
mawn94424143__mawn
outdrawn1245013outdrawn
pawn94625303__pawn
phrase11109903phrase
prawns11509023_prawns
pyran10514473pyra_n
rain46251733__rain
ran38266623__ra_n
raw67252253__raw_
rawin85521473__rawin
raws75238213__raws
redrawn11245953redrawn
reran57329103rera_n
resawn9399953resawn
saran53730303sara_n
sawn75428163__sawn
scrawl11208093scrawl
scrawny15213943scrawny
sharn84823703sh_arn
shaw108132553sh_aw_
shawl116217573sh_awl
shawm135316153sh_awm
shaws116226263sh_aws
shewn115715703sh_ewn
shoran94016043shora_n
shown115216483sh_own
shrank13359123shrank
shrew119720173shrew_
shrewd136810783shrewd
shrews129313923shrews
spawn107811713_spawn
sprain83614863sprain
sprawl11188063sprawl
strain64919573strain
straw813321293straw_
straws98718673straws
strawy1210312823strawy
strewn96710013strewn
strown96812093strown
tain45548073t__ain
tan37167583t__a_n
tarama8412733tarama
tarn46842723t__arn
tarpan82814293tarpan
tarpon82812803tarpon
tartan64217513tartan
tarzan152910753tarzan
taw610155453t__aw_
tawny114713653t__awny
taws75641593t__aws
terai53525483tera_i
terais64023513terais
teraph11319093teraph
tern46134803ter__n
terrain7410853terrain
thack144915173th_ack
thae76825563th_a_e
thane86122533th_ane
thank125817803th_ank
tharm105916643th_arm
tharms115712243tharms
that75639323th_a_t
thawed13458463th_awed
thawer12489343th_awer
thawing14378683th_awing
thegn95810903th_egn
thein85919023th_ein
then78429693th__en
therapy1536613therapy
therein102310353therein
thereon10199263thereon
therian10311293therian
thew108226233th_ew_
thews117416193th_ews
thewy146311853th_ewy
thiamin1236933thiamin
thiazin1945483thiazin
thin76732393th__in
thiram1139963thira_m
thirams1236823thirams
thorax1638253thora_x
thorn85318703th_orn
thoron94713903thoron
thralls10299043thralls
thraves13469713thraves
thrawart1445163thrawart
thread105011093thread
threads11419953threads
thready14435903thready
threap11569663threap
threaps12488643threaps
threat95020463threat
threaten1146303threaten
threats104311673threats
three87526913thr_ee
threep115910113threep
threes97117323threes
thresh12276863thresh
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrive125313223thrive
thriven13447023thriven
thro77726423thr__o
throat94819753throat
throats104612193throats
throaty13428483throaty
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
thrower1387003thrower
throwing1536723throwing
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrush12257483thrush
thrust91911893thrust
thruway1643163thruway
thwack1834213thwack
thwart12311683thwart
tirade7311693tirade
titan53318173tita_n
tolan55124013tola_n
toman75724053toma_n
tora47545993tora__
torah87125273tora_h
torahs95115643torahs
toras55540373tora_s
torn46044253tor__n
torten65314353torten
town76928703t__own
trace75829613t_race
track114823013t_rack
tract75635713t_ract
trad55630913t_ra_d
trade65026043t_rade
tragi64717173t_ragi
traik95418203t_raik
trail55126773t_rail
trains64725343t_rains
trait56940843t_rait
tram67034553t_ra_m
tramp96319773t_ramp
trams75327673t_rams
trank96222423t_rank
tranny94210863t_ranny
tranq145416893t_ranq
trans54933043t_rans
trap67532803t_ra_p
trapan82412973t_rapan
traps75727483t_raps
trapt76433393t_rapt
trash86119763t_rash
trass56226473t_rass
trave85223033t_rave
trawls94412393t_rawls
tray77632593t_ra_y
trays85623433t_rays
treen55622753t_reen
trews86118893t_rews
trow78031423t_row_
trows88826183t_rows
turaco839453turaco
turban8310483turban
tureen63312723tureen
turion6313163turion
turn46330393tur__n
turnon638193turnon
twain86313623t_wain
tyranny1343063tyranny
tyrant9315333tyrant
uhlan849113uhla_n
undrawn1145293undrawn
unsawn9317463unsawn
upthrown1642593upthrown
withdrawn1952323withdrawn
yawn106219093__yawn

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.406440125.6
2DLD Change Limit1127162494.90622975.1
3Display Results2492490.0763276.3
 (SQL Overall)1786912495.38833164.6
 
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.