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

282 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
unriper918828(None) 
unripe82012091unripe_
griper94114612_griper
juniper1634022jun_iper
riper74328402__riper
sniper84413642sn_iper
striper94514792striper
uniter64619142un_iter
unmiter9310392unmiter
unrimed102211632unrimed
unrip72012862unrip__
unripely1344632unripely
unripest1046082unripest
unripped1335762unripped
unrips8199452unrip_s
unrisen7229282unrisen
unroped102812102unroped
unwiser1037122unwiser
upriser9218762upriser
upriver12196932upriver
acrider1038623acrider
aerier64823153aeri_er
airier64619363airi_er
angrier839023angri_er
arider74717743_arider
arriver10117793arriver
briber104714053_briber
brier74527403_bri_er
briner84519043_briner
burier84324653buri_er
burrier93613553burri_er
caliper11410963caliper
carper104923633car_per
chirper14359963chirper
crier74724463_cri_er
crimper136510423_crimper
cripe95521143_cripe_
cripes105120873_cripes
crisper113511053_crisper
currier93316703curri_er
derider93214973derider
deriver114213913deriver
dorper94314573dor_per
draper94315693_draper
drier64423963_dri_er
dripper12349233_dripper
driver104714493_driver
dungier9368583dungi_er
eerier64320023eeri_er
encipher1544133encipher
enricher1345003enricher
enrober9218623enrober
enticer91510423enticer
envier939673envi_er
frier85225843_fri_er
frizer184011283_frizer
funkier14349983funki_er
funnier103210173funni_er
furrier103513663furri_er
furriner11267303furriner
gorier73719373gori_er
gripe84622963_gripe_
griped104114713_griped
gripers104011463_gripers
gripes94619873_gripes
gripey124111203_gripey
gripier103210323_gripier
gripper124410713_gripper
groper94517253_groper
gunkier12369553gunki_er
gunpaper1342623gunpaper
harper115018403har_per
hungrier1233893hungri_er
hunkier144512143hunki_er
hurrier103412943hurri_er
inciter93113773inciter
inditer83514233inditer
inkier104013783inki_er
inlier63615363inli_er
insider849733insider
inviter104112313inviter
junipers1733933jun_ipers
junkier18339493junki_er
knapper15387153knapper
knifer13598563kn_ifer
lorimer937753lorimer
loriner7511893loriner
lunier64617603lun_i_er
mariner93315993mariner
mirier83918363miri_er
nailer64119363_nailer
naiver94311353_naiver
napper103718283_napper
nicer74618293_n_icer
nipper103715713_nipper
niter55028973_n_iter
nurser64314503nur_ser
onerier7311613oneri_er
outrider92410563outrider
peripter1278753peripter
piper96523193__piper
pricer103918293_pricer
prier75027763_pri_er
primer105118683_primer
prizer174714883_prizer
proper104319953_proper
punier84519223pun_i_er
punkier133512793punki_er
punnier93511263punni_er
querier16310013queri_er
raper74932753__raper
ricer74726613__ricer
rider65231303__rider
rifer84721983__rifer
rimer75429243__rimer
ripe66038923__ripe_
riped85226433__riped
ripen75619263__ripen
ripes75435773__ripes
ripper103518653__ripper
riser55431053__riser
river85731693__river
roper75431913__roper
runnier74010113runni_er
runtier73512853runti_er
scraper114513423scraper
scriber113910973scriber
scrimper1455763scrimper
scripter12137783scripter
shrimper1544413shrimper
shriver134712193shriver
snapper113512073snapper
snider74413913sn_ider
snipe75320573sn_ipe_
sniped94913483sn_iped
snipers93311773sn_ipers
snipes83917393sn_ipes
snipper113911333snipper
snooper93511533snooper
sprier84119063spri_er
strider84315723strider
striker113714173striker
stripe85822443stripe_
striped105214363striped
stripers103911593stripers
stripes95320573stripes
stripier1058863stripier
stripper1247123stripper
striver104315203striver
sunnier73412153sunni_er
sunrise7310813sunrise_
sunrises8310693sunrises
thriver13479123thriver
trier54328533_tri_er
trimer85717153_trimer
tripe75425383_tripe_
tripes85324873_tripes
tripper113711923_tripper
triter65120593_triter
uglier748953ugli_er
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unbitter1046173unbitter
unciae83215313unciae_
uncover1239003uncover
under64624213un__der
undies73821963undi_es
undine7817263undine_
undines8716083undines
undoer73113043un_doer
undrape1049333undrape_
undraped1239393undraped
undrapes1138603undrapes
undried92314613undri_ed
uneager839753uneager
unexpert1744343unexpert
unfairer11184283unfairer
unfired112212453unfired
unfixed18218563unfixed
unfixes17238113unfixes
unhairer11174993unhairer
unhip10178823unhip__
unhired112512153unhired
unhoped13249353unhoped
unifier102211863unifier
unipod946853un_ipod
uniquer1675783uniquer
unisex1358353un_isex
unite54828383un_ite_
united74421543un_ited
uniters73814173un_iters
unites65024853un_ites
unitizer1746203unitizer
unkinder1335363unkinder
unlike102614063unlike_
unliked122411283unliked
unlimber1243373unlimber
unlined82515803unlined
unlive92712333unlive_
unlived112511373unlived
unlives102010953unlives
unmaker13279513unmaker
unmined102612953unmined
unmiters1037073unmiters
unmitre936993unmitre
unmixed17228213unmixed
unmixes16197753unmixes
unoiled82415483unoiled
unopen838913un_open
unpeg8309363un__peg
unpen72913573un__pen
unpile81914323unpile_
unpiled102312743unpiled
unpiles92112783unpiles
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
unraised91811883unraised
unraked122914013unraked
unrated82621553unrated
unravel1038063unravel
unrazed172511453unrazed
unreel63612933unr_eel
unreeler8127293unreeler
unrepair1042373unrepair
unribbed1334173unribbed
unriddler1142783unriddler
unrifled1237423unrifled
unrig61711413unri__g
unrigged1165643unrigged
unrigs7159003unri_gs
unrinsed938383unrinsed
unripened1244393unripened
unrobe82611673unrobe_
unrobed102711213unrobed
unrobes9269733unrobes
unrove92511683unrove_
unroven10238143unroven
unruled8311373unruled
unrulier845333unrulier
unsicker1435303unsicker
unsized172510543unsized
unsober967643unsober
unstriped1246303unstriped
untidier946783untidier
untie54425493unti_e_
untied73720813unti_ed
unties64326923unti_es
untimed102713373untimed
untipped1335763untipped
untired82316383untired
untried82615853untri_ed
untruer737113untruer
unwarier1136883unwari_er
unwinder1235613unwinder
unwise9510803unwise_
unzip16207623unzip__
unzipped2233213unzipped
unzips17175273unzip_s
upper93714263u__pper
upraiser10175843upraiser
uprise82313693uprise_
uprisen9227353uprisen
uprisers10206773uprisers
uprises92012733uprises
uprivers13215563uprivers
ureter6313203u_reter
urger64116473u_r_ger
urine55026603u_rine_
urines64724123u_rines
urped84615283u_r_ped
usurper934353usurper
varier94619353vari_er
verier94620963veri_er
viper105017303__viper
warier93722893wari_er
warper114015583war_per
wiper105421293__wiper
wirier94215553wiri_er
wrier84521753_wri_er
writer94416513_writer

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272826.42320866.7
3Display Results2822820.0933032.3
 (SQL Overall)1786912826.92225814.9
 
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.