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

205 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
retwist103948(None) 
retwists1135601retwists
betwixt1943732betwixt
entwist1048802entwist
intwist1038042intwist
metrist9317062metrist
realist73225382realist
relist64628412re_list
resist64524532re_sist
retest64028452ret_est
retint65633442ret_int
retwisted1344892retwisted
revuist1038472revuist
twist86820982__twist
untwist1047712untwist
altoist7313393altoist
artist64125543art_ist
autist64324943aut_ist
bemist105216953be_mist
betise85616273bet_ise
brewis11469983bre_wis_
cellist9314423cellist
centrist10314863centrist
deist64633593de__ist
delist74625053de_list
dentist8316743dentist
desist74818813de_sist
detest74122843det_est
dewiest11312343de_wiest
duettist945513duettist
egoist7612283_egoist
enlist6417043_enlist
entwists1156143entwists
erethism1345863erethism
etatist7415033_etatist
etuis54013133_etuis_
exist124618943_e_xist
feist86230073fe__ist
fetish12310373fet_ish
feudist1137573feudist
fewest12311663fe_west
frettiest1267063frettiest
heist87030913he__ist
intwists1145593intwists
jettiest15359593jettiest
leftist10279353leftist
legist71315253le_gist
lewis85315843le_wis_
lutist64317553lut_ist
metalist10519353metalist
metis75025903met_is_
metrists1039853metrists
neist54628443ne__ist
nettiest83112433nettiest
newest9314213ne_west
newish1237903ne_wish
nitwit938593nitwi_t
nitwits1035053nitwits
outwish13289853outwish
outwit93014593outwi_t
outwits103110863outwits
peewit111110903peewi_t
peewits12105873peewits
persist9315853persist
petit74332653pet_i_t
pettiest103113963pettiest
pettish1238283pettish
pewit104622793pe_wi_t
pewits112810683pe_wits
pietist9414033piet_ist
preexist1747963preexist
pretest9517633pret_est
prettiest1199803prettiest
protist9320223prot_ist
racist82822793r_acist
rapist82520673r_apist
ratfish1338773ratfish
rattiest83516113rattiest
rattish10510823rattish
rawest93615063r_awest
rawish123012913r_awish
readiest93719043readiest
realest73322433realest
realise73021813realise
realism93115923realism
realists83014843realists
rebait8320403rebai_t
rebaits9312573rebaits
rebuilt939973rebuilt
recast83422773re_cast
receipt1159253receipt
recit75235103re_ci_t
recits83621353re_cits
reddest9311953reddest
reddish1238033reddish
redfish1437793redfish
redipt94116743re_dipt
redwing122811983redwing
reediest92815423reediest
reedit7617223reedi_t
reedits8511743reedits
reefiest112811483reefiest
reekiest122711313reekiest
reemit8717223reemi_t
reemits9611303reemits
reenlist8410363reenlist
reest54938093re__est
refit84230063re_fi_t
refits94017653re_fits
regilt71217493re_gilt
reis45343233re__is_
reknit10312533rekni_t
reknits1137073reknits
relict83623903re_lict
relish93916953re_lish
relists73817053re_lists
relit55340683re_li_t
remint85329973re_mint
remise84221953re_mise
remiss84216353re_miss
remit75737223re_mi_t
remits85622943re_mits
remixt155014853re_mixt
renest64529713re_nest
repaint9318363repaint
repast83520633re_past
reposit9315863reposit
reprint9318983reprint
reprise92715043reprise
request16311023request
reraise7316313reraise
rerise64325633re_rise
resift94017723re_sift
resists74414923re_sists
resit54241043re_si_t
resits64725563re_sits
rest46459843re___st
restrict10313633restrict
retags73414303retags_
retail65522073retai_l
retails74718973retails
retain64523283retai_n
retains74522253retains
retaste72313133ret_aste
retems83914573retems_
retests73813853ret_ests
rethink1488883rethink
retia55326113ret_i_a
retial64724993ret_ial
retie55735303ret_i_e
retied75924983ret_ied
reties65436193ret_ies
retile65929673ret_ile
retime85321803ret_ime
retina65023383ret_ina
retine66237333ret_ine
retints74717013ret_ints
retire64927013ret_ire
retort66831143ret_ort
retorts76016513retorts
retract91318113retract
retreat7317533retreat
retrial7615553retrial
retried84419153retried
retries74129073retries
retrim83514873retri_m
retrims93612373retrims
retros63820193retros_
rets45352563ret__s_
retsina74710603retsina
retting83425883retting
retuse66617223ret_use
retwisting1445633retwisting
retying113213833retying
revest94623603re_vest
revise94019743re_vise
revisit10311373re_visit
revuists1135153revuists
rewash1237673re_wash
rewet85135153re_w_et
rewets94617213re_wets
rewin85623963re_wi_n
rewind104715883re_wind
rewins95020823re_wins
rewire95421403re_wire
ritziest17237843ritziest
rotis56327053rot_is_
ruttiest82712663ruttiest
ruttish1048303ruttish
sexist133013483se_xist
tennist72813113tennist
tetris62816293tetris_
titlist7312923titlist
twists9549753__twists
twisty12426863__twisty
twit76329063__twi_t
twits86015793__twits
twixt155512483__twixt
untwists1144623untwists
verist93823893ve_rist
weftwise1741813weftwise
wettest10239363wettest
wettish1335963wettish
wist78049293___wist
yetis85418393yet_is_

Search took 9 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.220812231.8
2DLD Change Limit1340272058.31016128.4
3Display Results2052050.1261627.0
 (SQL Overall)1786912058.65620643.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.