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

263 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
sprained113843(None) 
strained9412251strained
brained103816102_brained
drained93713252_drained
grained93814272_grained
pained95622852_p_ained
plained103812232_plained
praised104214812_praised
prawned1346742_prawned
rained75024602__rained
sained75424242s__ained
sardined10268662sardined
shrined114112412shr_ined
spanned104111222sp_anned
spavined1434332spavined
spawned13316802sp_awned
speaned103411522spea_ned
spined95423942sp__ined
splined105013112sp_lined
sprain83614862sprain__
sprains93013592sprain_s
sprawled1434522sprawled
sprayed13398902spra_yed
springed123911322spr_inged
sprinted113411162spr_inted
stained84215342s_tained
strainer8512222strainer
trained84117202_trained
upraised11167412upraised
appraised1445593appraised
aproned10311503apr_oned
arraigned11103033arraigned
attained997353attained
bargained1344953bargained
braided114013213_braided
brailed103914013_brailed
braised104014803_braised
branned104311693_branned
brined95118413_br_ined
captained1446193captained
chained133812693_chained
craned96121653_cra_ned
curtained1265503curtained
deraigned1244093deraigned
derailed102410403derailed
detained103111643detained
detrained1158913detrained
dispraised1446403dispraised
distrained1257673distrained
drainer83012843_drainer
engrained1145493engrained
entrained1089413entrained
ermined10410603_ermined
explained1944543explained
gained84617463__gained
grainer83714063_grainer
groined92710813_groined
ingrained1145383ingrained
margined1237743margined
mistrained1347583mistrained
moraine9314573moraine_
moraines10314363moraines
obtained1136533obtained
opined95113853op__ined
ordained1035183ordained
paiked135113433_p_aiked
painted104214633_p_ainted
paired95017523_p_aired
paned85437183_p_a_ned
panned94123433_p_anned
patined105114783_patined
pawned124513283_p_awned
peined94918843_p_eined
pertained1238503pertained
pined85935323_p__ined
plaided11409643_plaided
plainer93811983_plainer
plaited103713893_plaited
planed94420913_pla_ned
planned103810153_planned
praise84419413_praise_
praiser93413943_praiser
praises94121103_praises
praline93019743_praline_
pralines102217723_pralines
pranced123714043_pranced
pranged114512553_pranged
pranked143712093_pranked
prated94924923_pra_ted
prawner1246803_prawner
prayed124815433_pra_yed
preened103214993_preened
priced115018883_pr_iced
prided103618033_pr_ided
pried84426863_pr_i_ed
primed115118913_pr_imed
prinked143412163_pr_inked
printed104016373_pr_inted
prised94322203_pr_ised
prized184415393_pr_ized
propined133111503_propined
pruned93413113_pr_uned
raided85017703__raided
railed74727543__railed
raised76120333__raised
ravined115411823__ravined
refrained1347223refrained
regained102111243regained
reined74425523__reined
remained112412893remained
reraised9312353reraised
restrained1148413restrained
retained93016093retained
retrained10411313retrained
ruined74813323__ruined
sailed74327763s__ailed
sainted84114243s__ainted
saned65636273s__a_ned
sardine83317393sardine_
sardines92815563sardines
scanned104110893s_canned
scragged1335823scragged
scraiched1744203scraiched
scraighed1643593scraighed
scrammed1555003scrammed
scrannel1044033scrannel
scraped124313133scra_ped
scrapped1556533scrapped
scrawled1445923scrawled
screened1137413screened
scribed124510643scr_ibed
scried95817303scr_i_ed
scrived134511113scr_ived
seined74023063s__eined
sequined18105653sequined
seriated92717023seriated
serifed11811463ser_ifed
serine65432673ser_ine_
serines74229543ser_ines
serried82513963serri_ed
serviced1435613serviced
shined104620783s__hined
shrapnel1342133shrapnel
shrine94920053shr_ine_
shrines104618693shr_ines
shrived144712183shr_ived
skeined1236773s_keined
snailed83811923s_nailed
sordine82515233sordine_
sordines92414073sordines
sorned74820043sor__ned
sortied83314103sorti_ed
spaced114517253sp_a_ced
spaded103816753sp_a_ded
spaed85522273sp_a__ed
spalled103113133sp_alled
spammed14348523sp_ammed
spaniel948923sp_aniel
spanked143111733sp_anked
spanner94312563sp_anner
spared95427493sp_a_red
sparged113512763sp_arged
sparid94016933spari__d
sparing104823873sparin_g
sparked143513143sp_arked
sparkled15317733sparkled
sparred104512863sp_arred
spasmed12296993sp_asmed
spathed134013183sp_athed
spatted104014143sp_atted
spawner12347363sp_awner
spayed124213613sp_a_yed
speared104314423spea_red
speiled104412123sp_eiled
speired103811103sp_eired
spermine12311433spermine_
spermines13310543spermines
spiced115218313sp__iced
spied85427713sp__i_ed
spiked134915553sp__iked
spiled94621993sp__iled
spine76534423sp__ine_
spinel85317333sp__inel
spines85132033sp__ines
spinet85629753sp__inet
spiraled1137733spira_led
spiralled1244403spiralled
spired94921863sp__ired
spirited1148973spirited
spited94820443sp__ited
splashed1435593splashed
splatted11356743splatted
splayed13357813spla_yed
spliced124310593sp_liced
spline86020533sp_line_
splines94718893sp_lines
splinted11369253sp_linted
spoiled104811353sp_oiled
spooned103412443sp_ooned
spraddled14203463spraddled
spraining1248153spraining
sprang95713523spra_n_g
sprangs104610053spra_ngs
sprattled1263313sprattled
sprawler1334653sprawler
sprayer12369043spra_yer
spraying14299883sprayin_g
sprier84119063spr_i_er
sprigged13316223sprigged
spring94526013spr_in_g
springe103913983spr_inge
springer113311753spr_inger
springes114014033spr_inges
springs104415923spr_ings
springy13359663spr_ingy
sprinkled1633713spr_inkled
sprint84526793spr_in_t
sprinter103810813spr_inter
sprints94113773spr_ints
sprite84421773spr_ite_
sprites94220333spr_ites
spritzed2044803spritzed
sprouted1136393sprouted
spruced12307533spr_uced
spurned10339263sp_urned
stainer73614923s_tainer
staned74824643s_ta_ned
strafed114413333stra_fed
strain64919573strain__
strainers9510383strainers
strains74218153strain_s
straiten838613straiten
straitened1143783straitened
straiter8311783straiter
straked125415343stra_ked
strand74514823stra_n_d
stranded102710813stranded
strapped1357823strapped
strawed114813613stra_wed
strayed114513283stra_yed
striated93414153striated
stringed102911873str_inged
striped105214363str_iped
strived114713663str_ived
surmised1136863surmised
survived1534073survived
sustained1045383sustained
swanned11358173s_wanned
syringed13377583syr_inged
traiked123310453_traiked
trailed83415673_trailed
trainee72817793_trainee
trainer73316793_trainer
trined74920713_tr_ined
undrained1138523undrained
unraised91811883unraised
unstrained1146373unstrained
untrained10510993untrained
upbraided1542963upbraided
upraise9158603upraise_
upraiser10175843upraiser
upraises10188473upraises
uprated103213323upra_ted

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622637.04620744.0
3Display Results2632630.0932828.0
 (SQL Overall)1786912637.56223630.1
 
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.