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

403 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
rapists9251075(None) 
papists112110451papists
racists92613321racists
rapist82520671rapist_
agists75713172_agists
artists74215592artists
baptists1236722baptists
harpists1338102harpists
lapises93513462lapises
maists85817572ma_ists
oralists8611802oralists
papisms13238542papisms
papist102618752papist_
racisms112310812racisms
racist82822792racist_
raises64826542ra_ises
rapids94913892rapi_ds
rapiers95012872rapiers
rapines95120862rapines
realists83014842realists
relists73817052relists
repasts93611932repasts
resists74414922resists
riposts9279402riposts
sadists83310852sadists
tanists7313662tanists
tapises92914012tapises
typists1236172typists
waists97415452wa_ists
adits66523713_adi_ts
ageists848493ageists
agisms9399393_agisms
agist66325583_agist_
airts55626343_a_irts
aits46355543_a_i_ts
alist56136783_alist_
amiss75823073_amis_s
anapests1046613anapests
angsts738863_angsts
anises64826703_anises
aorists74215833aorists
apices104916263_apices
apish105116643_apis_h
apses76823913_ap_ses
apsis75718293_ap_sis
arbalists1148483arbalists
arises65233803_arises
arista6415293_arista
aristas7413523_aristas
aristo6414033_aristo
aristos7312383_aristos
armpits1157133armpi_ts
aroints7313133aroints
arpents93613083arpents
arrests73312683arrests
arrises71617583arrises
artist64125543artist_
artiste73813693artiste
artistes83213353artistes
aspises9611643aspises
assists738473assists
atavists1137583atavists
aurists74615783aurists
autists73814853autists
avisos95410483_avisos
axises134413993_axises
baits76630583ba_i_ts
baptises1238923baptises
baptisms1446033baptisms
baptist11311873baptist_
barista9310823barista
baristas1039723baristas
bassists1037183bassists
basts75936933ba__sts
batiste939743batiste
batistes1039713batistes
bemists113410703bemists
braises93818873bra_ises
cambists1437023cambists
camisas113411923camisas
camises114218463camises
capias10318353capi_as
capiases1239253capiases
capita102913773capi_ta
capizes20410373capizes
caplets114914523caplets
capsids1239333capsids
casts77237793ca__sts
casuists1036523casuists
ceramists1346723ceramists
cists76624533__cists
cladists1136723cladists
copyists1545993copyists
crampits1436273crampi_ts
cubists11359023cubists
czarists1966223czarists
dadaists1045583dadaists
daises74318983da_ises
davits104012363davi_ts
deists74916433_deists
delists84414173delists
depicts12358463depicts
desists83611723desists
dialists9411413dialists
diarists9410363diarists
dualists958243dualists
easts57530323ea__sts
egoists887073egoists
enlists749393enlists
escapists1344253escapists
exists134710913_exists
faddists13235543faddists
faints94818783fa_ints
fascists1336613fascists
fasts86429683fa__sts
fauvists1443843fauvists
favisms1535443favisms
feists94915313_feists
fists85527543__fists
foists95413983_foists
fraises104215693fra_ises
gaits65726013ga_i_ts
galiots82311323galiots
gaposis1038423gaposis
gasts66628633ga__sts
gists66026193__gists
grapiest112211933grapiest_
grists74716483_grists
habits113014653habi_ts
haints94417583ha_ints
harpist12312363harpist_
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
imagists1175113imagists
imposts11269003imposts
insists739083insists
ironists839293ironists
joists134711033_joists
jurists14409123jurists
karsts106012943ka_rsts
kists95822123__kists
kraits104912203kra_i_ts
lapides103012043lapides
lapidists1244913lapidists
lapins84520683lapi_ns
lapis76223153lapi__s
lappets11329133lappets
lapses85217693lap_ses
lapsus8437273lap_sus
lariats7615053lariats
lasts57731263la__sts
latests73910313latests
legists899593legists
lists56628693__lists
lutists73810273lutists
lyrists1036963lyrists
maist75535683ma_ist_
masts77035763ma__sts
mavises122812993mavises
mists76633903__mists
monists93614783monists
moralists11311103moralists
muralists1148163muralists
nanisms938843nanisms
narcists1078113narcists
nudists8356833nudists
oasts56529183oa__sts
oboists937903oboists
odists749853_odists
onanists838413onanists
oralisms10610973oralisms
oralist7619633oralist_
organists1047383organists
paints85921833pa_ints
paisas84317493pa_isas
palmists12268813palmists
papism122211513papis_m
papistic1448733papistic
papistry1543723papistry
parises94827193parises
pasts75936503__pasts
pavises125315493pavises
pests75933273__pests
pianists1049013pianists
pints75936223__pints
pipits104713063pipi_ts
pisos76021063__pisos
piss65033343__pis_s
piste75824603__piste
pistes85325633__pistes
pits66348753__pi_ts
posts75228783__posts
praises94121113pra_ises
praxises1739063praxises
priapisms1545463priapisms
protists10313363protists
purists94014073purists
rabats83116223ra_bats
rabbets11279423rabbets
rabbits11299863rabbits
rabies85226023rabi_es
rachets124516833rachets
rachises131412413rachises
raciest92820013raciest_
racings105015133racings
racism103214193racis_m
rackets134916873rackets
radials83614643radials
radians83013823radians
radiants9259453radiants
radiate83416313radiate
radiates92415293radiates
radices102314263radices
radios74018673radi_os
radish103516923radis_h
radishes1269463radishes
radiums10299323radiums
radius73914873radi_us
radiuses937043radiuses
radixes15259343radixes
rafts87820633ra__fts
ragis66325603ragi__s
ragouts838543ragouts
raias54631123ra_i_as
raids65827523ra_i_ds
rails55937403ra_i_ls
rains55140233ra_i_ns
rais45252623ra_i__s
raise54828053ra_is_e
raised76120333ra_ised
raiser66620103ra_iser
raisers73617393ra_isers
raisin62716923ra_isin
raisins72715343ra_isins
raita54623073ra_i_ta
raitas64417673ra_itas
rakis95323443raki__s
rakish134313973rakis_h
rallyists1243333rallyists
ramets83517393ra_mets
ramies84630463rami_es
ramjets1635163ramjets
ramparts1245583ramparts
rampikes1635393rampikes
rampions12248023rampions
ranids75118703rani_ds
ranis55235843rani__s
ranpikes1435643ranpikes
rants55935343ra__nts
rapers84327183rap_ers
rapes75740723rap__es
raphes115117453rap_hes
raphias123511083raphias
raphides14188393raphides
raphis114014323rap_his
rapid86422033rapi__d
rapider1067903rapider
rapidest1138543rapidest
rapidity1446273rapidity
rapidly1336523rapidly
rapier84019993rapi_er
rapine85023083rapi_ne
raping94829853rapi_ng
rapini84714683rapi_ni
rappees113611453rappees
rappels11448803rappels
rappers113618443rappers
rapports1245963rapports
raps66247733rap___s
rapt67245313rap__t_
raptors94213353raptors
rarest65725483rarest_
rarity93615493rari_ty
rases55447213ra__ses
raspiest10311283raspiest_
raspings11337853raspings
raspish1298103raspis_h
rasps74316663ra__sps
ratines75328583ratines
ratings84217413ratings
rations74123433rations
ratios64922673rati_os
ratite65022423rati_te
ratites74920683ratites
rats46260373ra___ts
ravines104220233ravines
ravings114614503ravings
ravins94622563ravi_ns
ravish123414043ravis_h
ravishes1478043ravishes
rawest93615063rawest_
rawins95617623rawi_ns
rawish123012923rawis_h
realises82420183realises
realisms102212163realisms
realist73225383realist_
recasts93413533recasts
recits83621353reci_ts
reests64618893r_eests
refits94017653refi_ts
relicts94414593relicts
relist64628413relist_
remints95117293remints
remises93423483remises
remiss84216353remis_s
remits85622943remi_ts
renests74014213renests
repaints1038483repaints
repass84114703repas_s
repast83520633repast_
repeats94316053repeats
repents93717623repents
repines94927383repines
repins84924313repi_ns
replots93412633replots
reports94916213reports
reposes94021263reposes
reposits10310453reposits
repots85621003rep_ots
reprints1039903reprints
reprises102615463reprises
rerises73525883rerises
resifts10378703resifts
resist64524533resist_
resits64725563resi_ts
rests54935873r__ests
retests73813853retests
retints74717013retints
retwists1135603retwists
revests104413733revests
revises104220533revises
revisits1137423revisits
revuists1135153revuists
rifts85718643r__ifts
riots54922013r__iots
ripest84317943ripest_
ripost83615003ripost_
riposte9269623riposte
ripostes10239093ripostes
rises55244043r__ises
risks94917063r__isks
risus54216393r__isus
roasts64915413r_oasts
roosts64916323r_oosts
ropiest93317773ropiest_
rousts617016723r_ousts
royalists12178113royalists
rupiahs1253333rupiahs
ruralists947643ruralists
rusts55026993r__usts
sacrists1039563sacrists
sadisms10359113sadisms
sadist74221353sadist_
saints65122423sa_ints
sapiens9310173sapiens
sapients1037423sapients
sapphists1644113sapphists
schists1248543schists
sexists14267673sexists
shists96515113_shists
sophists1347293sophists
spaits85017473spai_ts
spirts85317133_spirts
spits74429553_spi_ts
statists8310163statists
tachists1348183tachists
taints64520533ta_ints
tamises92715973tamises
tanist6324613tanist_
tapirs84113173tapi_rs
tapis75028863tapi__s
tappets113610013tappets
theists1039153theists
therapists1544403therapists
traipses1036873traipses
traits65121983tra_i_ts
transits8313503transits
trapeses1039153trapeses
trapezists2152923trapezists
trapnests1144433trapnests
tropisms1247723tropisms
tsarists857303tsarists
tubists9288323tubists
twists9549753_twists
typist1139823typist_
tzarists1755693tzarists
uranisms1099973uranisms
urbanists11105483urbanists
utopists1045773utopists
valises103516273valises
vasts86423773va__sts
verists103613673verists
vibists1256483vibists
waist86132383wa_ist_
waits88333523wa_i_ts
wapiti1138363wapi_ti
wapitis1236473wapitis
wasts87433673wa__sts
whists124613813_whists
wists86728523__wists
wrists95415643_wrists

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274036.59320328.7
3Display Results4034030.1402878.6
 (SQL Overall)1786914037.13925030.3
 
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.